Re: Cursors and PHP - Mailing list pgsql-general

From Steve Manes
Subject Re: Cursors and PHP
Date
Msg-id 40816B27.80904@magpie.com
Whole thread Raw
In response to Re: Cursors and PHP  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:

> Steve Manes <smanes@magpie.com> writes:
>
>>     $query = "SELECT get_user_data('$cursor', $user_id);FETCH ALL IN
>>$cursor;";
>
>
>>     $res =& $dbh->query($query);
>
>
> Hm.  This will return two different, not-compatible result sets (the
> SELECT's output and then the FETCH's).

Without the FETCH in that compound PHP query however, nothing gets
returned from the SELECT. I'm not sure why but maybe it's because
PEAR::DB doesn't have any direct support for cursors so it's just
grabbing a result set.




pgsql-general by date:

Previous
From: "Bruno BAGUETTE"
Date:
Subject: ERROR: NEW used in non-rule query (was Parse error a in short stored procedure : What's wrong ?)
Next
From: Pascal Polleunus
Date:
Subject: Re: ERROR: NEW used in non-rule query (was Parse error