Re: PHP 4.0 Bug #8399 Updated: Only the first results sets can be retrieved
| From: | steeven | Date: | Fri, 05 Jan 2001 00:22:53 +0000 |
| Subject: | Re: PHP 4.0 Bug #8399 Updated: Only the first results sets can be retrieved | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-43002@lists.php.net to get a copy of this message | ||
For example: system store procedure sp_cursor will generate 2 result set and only the 2nd set
contained usefull data.
> ID: 8399
> Updated by: fmk
> Reported By: steeven@kali.com.cn
> Old-Status: Open
> Status: Closed
> Bug Type: MSSQL related
> Assigned To:
> Comments:
>
> mssql_query can be used to execute miltible SQL statements but only one record set will be
> returned.
>
> You can split multible statements into separete calls to mssql_query and get a result for each
> statement.
>
> Previous Comments:
> ---------------------------------------------------------------------------
>
> [2000-12-24 03:34:42] steeven@kali.com.cn
> Only the first results set can be retrieved.
> This greatly limit the use of cursor.
>
> mssql_fetch_object($result,$set) //$set may help.
>
>
> ---------------------------------------------------------------------------
>
>
> Full Bug description available at: http://bugs.php.net/?id=8399