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.