BUG #6550: Querry failed while using throung php program. - Mailing list pgsql-bugs

From mkkrish@hotmail.com
Subject BUG #6550: Querry failed while using throung php program.
Date
Msg-id E1SAb4c-00036i-Ej@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #6550: Querry failed while using throung php program.
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6550
Logged by:          M K Krishnan
Email address:      mkkrish@hotmail.com
PostgreSQL version: 9.0.4
Operating system:   Windows 7
Description:=20=20=20=20=20=20=20=20

11Variety One Warning: pg_query(): Query failed: ERROR: syntax error at or
near "and" LINE 1: select * from variety_dir where crop_cd=3D and variety_c=
d=3D1
^ in C:\Program Files
(x86)\PostgreSQL\EnterpriseDB-ApachePhp\apache\www\agrimetnew\variety_upd.p=
hp
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.p=
hp
on line 33 No Record Found .

Query works from SQL Screen. When uses through php it fails.

pgsql-bugs by date:

Previous
From: jf.vanderwoude@gmail.com
Date:
Subject: BUG #6549: Wrong $PATH setting after installation
Next
From: aburacze@gmail.com
Date:
Subject: BUG #6551: PL/pgSQL: GET DIAGNOSTICS not working for first OUT parameter