ID: 37399
Comment by: jplock at gmail dot com
Reported By: aranna at free dot fr
Status: Open
Bug Type: Feature/Change Request
Operating System: REH3
PHP Version: 5.1.4
New Comment:
This used to work for us using FreeTDS 0.63 on Solaris 9 with PHP
5.1.2, but after upgrading to PHP 5.1.4, we can not retrieve multiple
result sets back using mssql_next_result(), it always returns false.
Previous Comments:
------------------------------------------------------------------------
[2006-05-10 14:40:08] aranna at free dot fr
Description:
------------
PHP is compiled with Sybase ct support (even if using freetds 0.64 or
Sybase open client). When i excute a stored procedure with more than
one result, it's impossible to retrieve them (only the firt).
Reproduce code:
---------------
Proc example :
create proc more_resultset as
//My first select
SELECT * FROM table 1
//My second
SELECT * FROM table 2
Expected result:
----------------
There is no way with sybase support to exploit more than one result set
(like mssql_next_result or mysqli_next_result).
I have got the right result when using "isql" client or "tsql" client
of Sybase or FreeTds on command line.
Actual result:
--------------
Having only the first select return
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=37399&edit=1
