ID: 35386
User updated by: slapaf at hotmail dot com
Reported By: slapaf at hotmail dot com
Status: Open
Bug Type: PDO related
Operating System: winxp sp2
PHP Version: 5.1.0
New Comment:
deleting row with "name 1" and inserting a "name 5" returns:
NULL :
string : name 3
string : name 4
string : name 5
Previous Comments:
------------------------------------------------------------------------
[2005-11-25 11:48:44] slapaf at hotmail dot com
array(2) {
["EVENT_NAME"]=>
NULL
[0]=>
NULL
}
array(2) {
["EVENT_NAME"]=>
string(6) "name 2"
[0]=>
string(6) "name 2"
}
array(2) {
["EVENT_NAME"]=>
string(6) "name 3"
[0]=>
string(6) "name 3"
}
array(2) {
["EVENT_NAME"]=>
string(6) "name 4"
[0]=>
string(6) "name 4"
}
------------------------------------------------------------------------
[2005-11-25 11:44:58] [EMAIL PROTECTED]
Change this line:
print '<pre>'.gettype($row['EVENT_NAME']).' : '.$row['EVENT_NAME'];
to
var_dump($row);
and paste the result here.
------------------------------------------------------------------------
[2005-11-25 11:38:32] slapaf at hotmail dot com
Description:
------------
When using PDO for simple query in Firebird it returns first row as
null.
I've tried using ADODB for control and it returns the correct results.
Reproduce code:
---------------
$dbh = new PDO("firebird:dbname=localhost:test.fdb","****","******");
$sql='SELECT EVENT_NAME FROM EVENTS';
foreach($dbh->query($sql) as $row){
print '<pre>'.gettype($row['EVENT_NAME']).' :
'.$row['EVENT_NAME'];
}
Expected result:
----------------
string : name 1
string : name 2
string : name 3
string : name 4
Actual result:
--------------
NULL :
string : name 2
string : name 3
string : name 4
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=35386&edit=1
