ID: 37399 User updated by: aranna at free dot fr Reported By: aranna at free dot fr Status: Assigned -Bug Type: MSSQL related +Bug Type: Sybase-ct (ctlib) related Operating System: REH3 PHP Version: 5.1.4 Assigned To: fmk New Comment:
Note this is Sybase not Mssql Previous Comments: ------------------------------------------------------------------------ [2006-05-16 06:29:49] [EMAIL PROTECTED] Assigned to the maintainer. ------------------------------------------------------------------------ [2006-05-16 03:00:42] jplock at gmail dot com Ok, more testing, after reverting to PHP 5.1.2 version of ext/mssql (still using PHP 5.1.4), our stored procedure calls work properly again. Something with those dbcancel() calls messes up mssql_next_result(), unfortunately. ------------------------------------------------------------------------ [2006-05-16 02:54:14] jplock at gmail dot com 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? ------------------------------------------------------------------------ [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
