| From: | mkkrish(at)hotmail(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #6550: Querry failed while using throung php program. |
| Date: | 2012-03-22 06:00:34 |
| Message-ID: | E1SAb4c-00036i-Ej@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 6550
Logged by: M K Krishnan
Email address: mkkrish(at)hotmail(dot)com
PostgreSQL version: 9.0.4
Operating system: Windows 7
Description:
11Variety One Warning: pg_query(): Query failed: ERROR: syntax error at or
near "and" LINE 1: select * from variety_dir where crop_cd= and variety_cd=1
^ in C:\Program Files
(x86)\PostgreSQL\EnterpriseDB-ApachePhp\apache\www\agrimetnew\variety_upd.php
on line 32 Warning: pg_num_rows() expects parameter 1 to be resource,
boolean given in C:\Program Files
(x86)\PostgreSQL\EnterpriseDB-ApachePhp\apache\www\agrimetnew\variety_upd.php
on line 33 No Record Found .
Query works from SQL Screen. When uses through php it fails.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | aburacze | 2012-03-22 17:38:00 | BUG #6551: PL/pgSQL: GET DIAGNOSTICS not working for first OUT parameter |
| Previous Message | Tom Lane | 2012-03-22 03:11:04 | Re: BUG #6529: Invalid numeric input syntax for 'select into' queries |