Problem: Sybase, PHP and multiple result sets
| From: | Herouth Maoz | Date: | Wed, 15 Aug 2001 06:34:47 +0000 |
| Subject: | Problem: Sybase, PHP and multiple result sets | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-62773@lists.php.net to get a copy of this message | ||
I have started working with Sybase lately, and it has come to my
knowledge that a single query can return multiple result sets in
Sybase, especially when using stored procedures.
Now, in ASP (sorry...), there are calls that allow retrieving the
next result set from the current result set. So in effect the result
sets are a linked list and you can access all of them.
In PHP, however, the result set returned is the first one, and I
don't see any method for retrieving the next result set. Does anybody
know of such a method? Does anybody have a suggestion for workaround?
Basically, in most of these cases, the important result set is
actually the last one, not the first, as the intermediate result sets
are mostly temporary results.
Herouth