Stephan: Thanks for the tip, as it helped me find the error. And it has been solved.
Bugs List: You might want to remove this report. It was a PEBCAK 100%. I feel pretty stupid about the whole thing (and my head hurts from the banging against the wall). Thanks for the quick response, though, it's greatly appreciated. Paul Redd-LaFlamme -----Original Message----- From: Stephan Szabo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 12:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [BUGS] Bug #726: PHP/PG ERROR: parser: parse error at or near "," On Wed, 31 Jul 2002 [EMAIL PROTECTED] wrote: > Paul Redd-LaFlamme ([EMAIL PROTECTED]) reports a bug with a severity of 1 > The lower the number the more severe it is. > > Short Description > PHP/PG ERROR: parser: parse error at or near "," > > Long Description > The SQL statement > INSERT INTO users (user_name, comp_id, password) VALUES ('Yuk',8,'Yuk'); > > works fine when typed directly into the postgres shell, but yields the error > > ERROR: parser: parse error at or near "," > > when, and only when the '8' is inserted into the string in PHP by any means. > > In other words, the SQL statement provided works fine when hardcoded, > but fails every single time (making my application useless) when the > integer insert value is inserted into the PHP statement by any means. Try turning on query logging to see what sql statement the backend thinks it's getting. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org