Skip site navigation (1) Skip section navigation (2)

BUG #6550: Querry failed while using throung php program.

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 (view raw or flat)
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.


Responses

pgsql-bugs by date

Next:From: aburaczeDate: 2012-03-22 17:38:00
Subject: BUG #6551: PL/pgSQL: GET DIAGNOSTICS not working for first OUTparameter
Previous:From: Tom LaneDate: 2012-03-22 03:11:04
Subject: Re: BUG #6529: Invalid numeric input syntax for 'select into' queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group