Bug #18429 Updated: mssql_query() crashes on stored procedure using a cursor on query that contains

ID: 18429 Updated by: sniper@php.net Reported By: hujbanan@yahoo.com Status: Open Bug Type: MSSQL related Operating System: Win2000 -PHP Version: 4CVS-2002-07-19 +PHP Version: 4.3.0-dev New Comment: version update Previous Comments: ------------------------------------------------------------------------ [2002-07-19 02:16:43] hujbanan@yahoo.com I use PHP statement mssql_query( "EXEC db_proc 1, 2, 3" ) {query B} to call stored procedure on MSSQL 2000 server, which produces output using cursor. Before it, I create global cursor using mssql_query( "DECLARE rowset CURSOR GLOBAL SCROLL FOR $query" ) {query A}. I need dynamically choose executed query, so I can't declare cursor in stored procedure. Statement {A} creates global cursor which is fetched and dropped in SP db_proc {B}. When I use as $query SQL command 'SELECT id FROM store', it works fine. But if I use something like 'SELECT id+1 AS col FROM store', PHP function mssql_query crashes. However, both of sequences of SQL queries run without problems in SQL Query Analyzer (SQL 2k). I found this problem on PHP version 4.2.0 for win32. I try latest version of PHP from http://snaps.php.net/win32/ (both, stable v4.2.2-dev and unstable v4.3.0-dev) but problem persists. I'm using Apache 1.3.20/PHP 4.2.0 on Win2k advanced server. I have step by step tryed Apache 2.0.39 with PHP v4.2.1, 4.2.2-dev and 4.3.0-dev, but with the same result. Can you tell me, what is wrong? Is it PHP bug or mistake in PHP/Apache configuration? I used default settings of PHP and Apache, PHP extensions: dba, mssql & gd. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=18429&edit=1