#21089 [Opn->Csd]: mssql_bind not returning output parameters from stored procedure call

ID: 21089 Updated by: fmk@php.net Reported By: lornie@magix.com.sg -Status: Open +Status: Closed Bug Type: MSSQL related Operating System: Windows 2000 Server SP3 PHP Version: 4.3.0RC3 & 4.3.0RC4 & PHP Version 4.3.1-dev New Comment: with php 4.3.1-dev you have two options to get output and return values from a stored procedure also returning results. 1) call mssql_execute with an optional skip parameter mssql_execute($stmt, true); 2) call mssql_next_result() for each result set returned by the SP. This way you can handle multiple results. When mssql_next_result() returns false you will have access to output parameters and return value. Previous Comments: ------------------------------------------------------------------------ [2003-01-15 00:09:26] lornie@magix.com.sg I am still facing the same problem after applying PHP Version 4.3.1-dev (Built On: Jan 15, 2003 01:30 GMT). Just in case this will be helpful, the stored procedure that I am using only return 1 resource link and 1 output parameter. ------------------------------------------------------------------------ [2003-01-09 12:09:18] fmk@php.net This bug has been fixed in CVS. In case this was a PHP problem, snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. In case this was a documentation problem, the fix will show up soon at http://www.php.net/manual/. In case this was a PHP.net website problem, the change will show up on the PHP.net site and on the mirror sites in short time. Thank you for the report, and for helping us make PHP better. This problem was caused by mssql_execute being able to retreive multiple results from a single stored procedure. ------------------------------------------------------------------------ [2002-12-22 20:53:46] lornie@magix.com.sg 4.3.0RC4 produce the same result ------------------------------------------------------------------------ [2002-12-18 20:03:23] lornie@magix.com.sg Making use of mssql_bind to retrieve output parameters from a stored procedure in MSSQL7 always return 0 when PHP operates in ISAPI or CGI mode under IIS5. It was noted that although it didn't return the parameter, however it is able to accept input parameters. It is also returning the query result. Just not the output parameter. It work fine in PHP4.23 when it is run on CGI mode. Did not test if ISAPI works though. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=21089&edit=1