PHP 4.0 Bug #8627: mssql_query and stored procedures
| From: | laurent dot lacroix at skiplan dot com | Date: | Wed, 10 Jan 2001 10:20:27 +0000 |
| Subject: | PHP 4.0 Bug #8627: mssql_query and stored procedures | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-43651@lists.php.net to get a copy of this message | ||
From: laurent.lacroix@skiplan.com
Operating system: Windows NT 4.0
PHP version: 4.0.3pl1
PHP Bug Type: MSSQL related
Bug description: mssql_query and stored procedures
when i call a stored procedure with mssql_query and if this
stored procedure raises an error then msssql_query returns false
here all is ok.
the problem is that all the following calls to mssql_query (in the same php script) also return
false whereas they should work.
example :
$result1 = mssql_query("stored_proc_that_raise_an_error");
-- here mssql_query returns false
$result2 = mssql_query("select * from MY_TABLE");
-- here $result2 also contains false whereas the
-- "select" query should work even if the precedent query
-- crash
The same script using obdc functions instead of mssql
works fine.
If the code of the stored procedure is passed as parameter of mssql_query then the
"select" query correctly works
--
Edit Bug report at: http://bugs.php.net/?id=8627&edit=1