Bug #8627 Updated: mssql_query and stored procedures

ID: 8627 Updated by: php-bugs@lists.php.net Reported By: laurent.lacroix@skiplan.com -Status: Feedback +Status: No Feedback Bug Type: MSSQL related Operating System: Windows NT 4.0 PHP Version: 4.0.3pl1 New Comment: No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". Previous Comments: ------------------------------------------------------------------------ [2002-06-07 10:59:34] k.schroeder@php.net Please try to recover with PHP 4.2.1. ------------------------------------------------------------------------ [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