#37399 [Com]: Stored Procedure with more than one Resultset

From: Date: Tue, 16 May 2006 01:13:14 +0000
Subject: #37399 [Com]: Stored Procedure with more than one Resultset
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-97158@lists.php.net to get a copy of this message 
 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

Thread (9 messages)

« previous php.bugs (#97158) next »