Re: Cursors and PHP

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.