RE: [PHP-DB] Postgres query failing, not enough info for debugging...

2009-06-17 Thread Ford, Mike
On 16 June 2009 15:57, Carol Walter advised: > Hello, > > I'm using PHP 5 and PostgreSQL 8.3.6. I have a query that is failing > and I don't know how to troubleshoot the problem. The error message > that it is giving is quite vague. The error message is as follows: > > > Warning: pg_query_pa

Re: [PHP-DB] Postgres query failing, not enough info for debugging...

2009-06-16 Thread Carol Walter
Yes, I have read that documentation. I have other queries in this same program with a similar structure that do work. One of these is as follows: $pg_pres_ins4 = pg_query_params("INSERT INTO \"brdgPresenters \" (\"peopleId\",\"presentationEventId\") VALUES ($1, currval('\"brdgPresentatio

Re: [PHP-DB] Postgres query failing, not enough info for debugging...

2009-06-16 Thread Jason Gerfen
Jason Gerfen wrote: Carol Walter wrote: Hello, I'm using PHP 5 and PostgreSQL 8.3.6. I have a query that is failing and I don't know how to troubleshoot the problem. The error message that it is giving is quite vague. The error message is as follows: Warning: pg_query_params() [function

Re: [PHP-DB] Postgres query failing, not enough info for debugging...

2009-06-16 Thread Jason Gerfen
Carol Walter wrote: Hello, I'm using PHP 5 and PostgreSQL 8.3.6. I have a query that is failing and I don't know how to troubleshoot the problem. The error message that it is giving is quite vague. The error message is as follows: Warning: pg_query_params() [function.pg-query-params]: Qu

[PHP-DB] Postgres query failing, not enough info for debugging...

2009-06-16 Thread Carol Walter
Hello, I'm using PHP 5 and PostgreSQL 8.3.6. I have a query that is failing and I don't know how to troubleshoot the problem. The error message that it is giving is quite vague. The error message is as follows: Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR