From:             [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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to