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

ID: 18429 Updated by: hujbanan@yahoo.com Reported By: hujbanan@yahoo.com Status: Open Bug Type: MSSQL related Operating System: Win2000 PHP Version: 4.3.0-dev New Comment: I download apache 1.3.26 from www.apache.org and latest PHP from listed URL, but it doesn't work. PHP still crashes. Both installed on Win 2000 Advanced Server. Previous Comments: ------------------------------------------------------------------------ [2002-07-19 12:10:56] sniper@php.net This is the snapshot for 4.3.0-dev: http://snaps.php.net/win32/php4-win32-latest.zip DO NOT REPLY unless you have _NEW_ information. DO NOT TOUCH the version anymore!!!! Also note that Apache2 is NOT stable for ANY use yet. Use Apache 1.3.26 which is proven to actually work (with PHP) ------------------------------------------------------------------------ [2002-07-19 09:56:33] hujbanan@yahoo.com I'm very sorry, I have to find PHP version, which do that correctly, so I've tried all available versions. Latest versions too. In combobox on 'Bugs Report - New' are only 4.1.2, 4.2.0, 4.2.1 and 4CVS-2002-07-19 versions selectable. Because of both latest versions (stable 4.2.2-dev and 4.3.0-dev) was uploaded to server snaps.php.net 2002/07/19, so I choose version 4CVS-2002-07-19. I've tried new update of latest stable version (http://snaps.php.net/win32/php4-win32-STABLE-latest.zip), and it is still not work. May be it is caused with my bad configuration of Apache/PHP. Because of this little misunderstanding, I'm not sure, which version you are modifying, so I don't know, which one I need to download. Could you, please, send me, if it is corrected and which archive I should to download. Thank you for your patient. ------------------------------------------------------------------------ [2002-07-19 08:52:13] sniper@php.net please don't change the version to earlier if you already confirmed it to happen with the LATEST.. ------------------------------------------------------------------------ [2002-07-19 08:24:51] hujbanan@yahoo.com I have tried new update of stable version, but with the same result, it doesn't work. I send to you some example of code, which cause troubles, because I believe, it can help you to debug this problem. stored procedure: ALTER PROCEDURE sp_fetch_row @row int = 1 AS OPEN GLOBAL rowset FETCH ABSOLUTE @row FROM GLOBAL rowset CLOSE GLOBAL rowset DEALLOCATE GLOBAL rowset GO php: function fetch_row( $link, $query, $row = 1 ) { if ( mssql_query( "DECLARE rowset CURSOR GLOBAL SCROLL FOR $query", $link ) ) { if ( $result = mssql_query( "EXEC sp_fetch_row $row", $link ) ) { $row = mssql_fetch_assoc( $result ); mssql_free_result( $result ); } else mssql_query( 'DEALLOCATE GLOBAL rowset', $link ); } return $row; } $result = fetch_row( $link, 'SELECT id, name FROM store', 3 ); // OK $result = fetch_row( $link, 'SELECT id*2, name FROM store', 3 ); // fails ------------------------------------------------------------------------ [2002-07-19 04:55:10] sniper@php.net version update ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/18429 -- Edit this bug report at http://bugs.php.net/?id=18429&edit=1