Thread: trying to run a query
Gurus,
I am working on a script in PHP that will be run nightly to delete and update a system.
What I am getting is the following error
Pg_exec(): Query Failed: ERROR : parser: parse error at or near ".
What I have is a connection string that ties database connectivity to sql string and then I try to insert data read from an array..
Any ideas on why this could be happening.
Thanks
Hari
On Thu, 2004-07-22 at 11:16, Hari Bhanujan wrote: > Gurus, > > > > I am working on a script in PHP that will be run nightly to delete and > update a system. > > > > What I am getting is the following error > > > > Pg_exec(): Query Failed: ERROR : parser: parse error at or near ". > > > > What I have is a connection string that ties database connectivity to > sql string and then I try to insert data read from an array.. > > > > Any ideas on why this could be happening. Post your code...
Scott Marlowe wrote: >On Thu, 2004-07-22 at 11:16, Hari Bhanujan wrote: > > >>Gurus, >> >> >> >>I am working on a script in PHP that will be run nightly to delete and >>update a system. >> >> >> >>What I am getting is the following error >> >> >> >>Pg_exec(): Query Failed: ERROR : parser: parse error at or near ". >> >> >> >>What I have is a connection string that ties database connectivity to >>sql string and then I try to insert data read from an array.. >> >> >> >>Any ideas on why this could be happening. >> >> > >Post your code... > > >---------------------------(end of broadcast)--------------------------- >TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > > You're somehow passing HTML-escaped code to PostgreSQL. Jeff