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

ID: 21089 User updated by: lornie@magix.com.sg Reported By: lornie@magix.com.sg -Status: Closed +Status: Open Bug Type: MSSQL related Operating System: Windows 2000 Server SP3 -PHP Version: 4.3.0RC3 & 4.3.0RC4 +PHP Version: 4.3.0RC3 & 4.3.0RC4 & PHP Version 4.3.1-dev New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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