[BUGFIX 21089/21328] MSSQL not returning values of SP output parameters in 4.3.0
| From: | Michael Sisolak | Date: | Wed, 08 Jan 2003 21:40:31 +0000 |
| Subject: | [BUGFIX 21089/21328] MSSQL not returning values of SP output parameters in 4.3.0 | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-93272@lists.php.net to get a copy of this message | ||
A bug was introduced into mssql_execute with version 1.89 of
php_mssql.c (as reported in the bug database as bugs #21089 and #21328)
which is included in the 4_3 branch. While this patch allowed a SQL
Server stored procedure to return multiple record sets, it prevented it
from ever returning the values of any output parameters. The call to
_mssql_get_sp_result was put inside an else clause that was never
called as long as the stored procedure executed correctly.
The attached patch is one solution: it resets the value of
retval_results to indicate all results have been read and breaks the
else back out into its own if clause. I'm not sure if this is really
needed - we may be able to just call _mssql_get_sp_result where this
patch adds the reset of the retval_results value.
Michael Sisolak
msisolak@yahoo.com
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com