[PHP-DEV] PHP 4.0 Bug #8627: mssql_query and stored procedures From: laurent.lacroix <email protected>
Date: 01/10/01

From: laurent.lacroix <email protected>
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

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>