PHP 4.0 Bug #8627: mssql_query and stored procedures

From: 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

« previous php.dev (#43651) next »