ID: 19734 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: Windows XP PHP Version: 4.2.3 New Comment:
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. Previous Comments: ------------------------------------------------------------------------ [2002-10-03 06:34:18] [EMAIL PROTECTED] I have a table of several thousand rows in a MSSQL database called amfull. Tried to query this: SELECT Distance FROM journeys WHERE VehicleBoxNo='44000601' PHP bombed out on me. Got the XP error "PHP.EXE has generated errors" So i played around a bit and discovered that if I did the following it prevented PHP from bombing out. SELECT TOP 100 Distance FROM journeys WHERE VehicleBoxNo='44000601' Unfortunately all this does is limit the number of rows to 100 which, in some cases, is very limiting. Any suggestions? ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19734&edit=1