Bug #8627 Updated: mssql_query and stored procedures

ID: 8627 Updated by: k.schroeder@php.net Reported By: laurent.lacroix@skiplan.com -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows NT 4.0 PHP Version: 4.0.3pl1 New Comment: Please try to recover with PHP 4.2.1. Previous Comments: ------------------------------------------------------------------------ [2001-01-10 05:20:27] laurent.lacroix@skiplan.com 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 this bug report at http://bugs.php.net/?id=8627&edit=1