|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2003-10-10 04:24 UTC] fjortiz at comunet dot es
Description:
------------
I helped create the mssql_execute function, and I see a bug has been introduced since 4.1.1 (last time I saw the code)
If you craft a stored procedure returning BOTH a recordset and output variables, you'll only get the recordset, not the output variables. This worked fine in 4.1.1
Here is the problem:
php_mssql.c, line 2110
if ((num_fields = dbnumcols(mssql_ptr->link)) > 0) {
// then get recordset...
}
else { // get output variables
_mssql_get_sp_result(mssql_ptr, statement TSRMLS_CC);
}
this is wrong. You can get both of them. This is it:
if ((num_fields = dbnumcols(mssql_ptr->link)) > 0) {
// then get recordset...
}
// and ALWAYS get the output variables
_mssql_get_sp_result(mssql_ptr, statement TSRMLS_CC);
I recompiled 4.3.3 php_mssql.dll with this and it works as expected (and as it was back in 4.1.1)
BTW it's in 4.3.4rc1 too.
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Oct 25 15:00:01 2025 UTC |
Hi All, I had the same problem about recordset and output value both not getting returned. I have made the modifications to PHP_MSSQL.dll and compiled it successfully and incase anyone wants the binary just drop a mail and I will be glad to send you the compiled DLL file. The new DLL file has been tested in my application and will help all other fellow developers as they wont have to recompile the file again. This will be my small contribution to the Open Source World. Regards, Rajesh Kumar