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:
http://cvs.php.net/viewcvs.cgi/php-src/ext/mssql/php_mssql.c?r1=1.152.2.12&r2=1.152.2.13&pathrev=PHP_5_1 In between those differences, a dbcancel(mssql_ptr->link); was added on line 1237 of php_mssql.c. In my case, we're executing a stored procedure which returns five different result sets. One of those result sets calls another stored procedure, which is failing because we're passing in a null value (its suppose to be a real value from the first stored procedure call), and is generate a "query failed" error. Could that 2nd "query failed" error be terminating the link and all of the previous result sets? Previous Comments: ------------------------------------------------------------------------ [2006-05-16 01:13:13] jplock at gmail dot com 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. ------------------------------------------------------------------------ [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
