#36676 [NEW]: PDO resultset for Firebird does not return 1st row values

From: Date: Fri, 10 Mar 2006 07:09:17 +0000
Subject: #36676 [NEW]: PDO resultset for Firebird does not return 1st row values
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-94117@lists.php.net to get a copy of this message
From: astro101 at hotmail dot com Operating system: Win XP SP2 PHP version: 5.1.3RC1 PHP Bug Type: PDO related Bug description: PDO resultset for Firebird does not return 1st row values Description: ------------ When querying a firebird database with pdo the values returned for the 1st row of the resultset are empty. If you change your order or delete a entry the 1st row values still return nothing. Reproduce code: --------------- $db = new PDO ("firebird:dbname=localhost:c:/mydb.fdb", 'SYSDBA', 'masterkey'); try{ $query = 'select * from HandsetsMake;'; $res = $db->query($query); while($row = $res->fetch(PDO::FETCH_NUM)){ echo 'Result: '.$row[0].'<br />'; } $cms->commit(); }catch (Exception $e){ echo 'caught exeption: '.$e->getLine().$e->getMessage(); } Expected result: ---------------- Result:1 Result:2 Result:3 Result:4 Actual result: -------------- Result: Result:2 Result:3 Result:4 -- Edit bug report at http://bugs.php.net/?id=36676&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=36676&r=trysnapshot44 Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=36676&r=trysnapshot51 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=36676&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=36676&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=36676&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=36676&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=36676&r=needscript Try newer version: http://bugs.php.net/fix.php?id=36676&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=36676&r=support Expected behavior: http://bugs.php.net/fix.php?id=36676&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=36676&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=36676&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=36676&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=36676&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=36676&r=dst IIS Stability: http://bugs.php.net/fix.php?id=36676&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=36676&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=36676&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=36676&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=36676&r=mysqlcfg

« previous php.bugs (#94117) next »