#19734 [NEW]: PHP wont fetch all rows in a MSSQL query

From: andrew@fpef.co.za Operating system: Windows XP PHP version: 4.2.3 PHP Bug Type: MSSQL related Bug description: PHP wont fetch all rows in a MSSQL query 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 bug report at http://bugs.php.net/?id=19734&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=19734&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=19734&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=19734&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=19734&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=19734&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=19734&r=support Expected behavior: http://bugs.php.net/fix.php?id=19734&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=19734&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=19734&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=19734&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=19734&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=19734&r=dst