#18429 [NoF]: mssql_query() crashes on stored procedure using a cursor on query that contains

ID: 18429 Updated by: fmk@php.net Reported By: hujbanan@yahoo.com Status: No Feedback Bug Type: MSSQL related Operating System: Win2000 PHP Version: 4.3.0-dev New Comment: You can use mssql_execute() if you want to get results back from stored preocedures. When you execute a command not returning data the MSSQL extension will close the transaction and releasse any declared variables. You can send more than one statement in a single query: mssql_query("DECLARE rowset CURSOR GLOBAL SCROLL FOR $query EXEC sp_fetch_row $row"); Previous Comments: ------------------------------------------------------------------------ [2002-12-24 01:00:03] php-bugs@lists.php.net No feedback was provided for this bug for over 2 weeks, 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". ------------------------------------------------------------------------ [2002-12-08 10:34:39] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip ------------------------------------------------------------------------ [2002-07-19 14:45:37] hujbanan@yahoo.com 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. ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ 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