#35386 [Opn->Asn]: first row is null
ID: 35386
Updated by: [EMAIL PROTECTED]
Reported By: slapaf at hotmail dot com
-Status: Open
+Status: Assigned
Bug Type: PDO related
Operating System: winxp sp2
PHP Version: 5CVS-2006-12-02 (snap)
-Assigned To:
+Assigned To: wez
Previous Comments:
[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 ''.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
#35386 [Opn->Asn]: first row is null
ID: 35386
Updated by: [EMAIL PROTECTED]
Reported By: slapaf at hotmail dot com
-Status: Open
+Status: Assigned
Bug Type: PDO related
Operating System: winxp sp2
PHP Version: 5CVS-2006-12-02 (snap)
Assigned To: abies
New Comment:
Ard, do you still maintain PDO_FIREBIRD?
Previous Comments:
[2005-11-25 11:58:10] [EMAIL PROTECTED]
Assigned to the maintainer.
[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 ''.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
#35386 [Opn->Asn]: first row is null
ID: 35386
Updated by: [EMAIL PROTECTED]
Reported By: slapaf at hotmail dot com
-Status: Open
+Status: Assigned
Bug Type: PDO related
Operating System: winxp sp2
PHP Version: 5.1.0
Assigned To: abies
Previous Comments:
[2006-01-02 10:17:34] slapaf at hotmail dot com
The result is the same using dev-version.
[0]=>
array(2) {
["EVENT_NAME"]=>
NULL
[0]=>
NULL
}
[1]=>
array(2) {
["EVENT_NAME"]=>
string(6) "name 3"
[0]=>
string(6) "name 3"
}
[2]=>
array(2) {
["EVENT_NAME"]=>
string(6) "name 4"
[0]=>
string(6) "name 4"
}
[3]=>
array(2) {
["EVENT_NAME"]=>
string(6) "name 5"
[0]=>
string(6) "name 5"
}
[2005-12-30 01:00:05] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, 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".
[2005-12-22 10:38:03] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5.1-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.1-win32-latest.zip
[2005-11-25 11:58:10] [EMAIL PROTECTED]
Assigned to the maintainer.
[2005-11-25 11:55:38] slapaf at hotmail dot com
deleting row with "name 1" and inserting a "name 5" returns:
NULL :
string : name 3
string : name 4
string : name 5
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/35386
--
Edit this bug report at http://bugs.php.net/?id=35386&edit=1
#35386 [Opn->Asn]: first row is null
ID: 35386
Updated by: [EMAIL PROTECTED]
Reported By: slapaf at hotmail dot com
-Status: Open
+Status: Assigned
Bug Type: PDO related
Operating System: winxp sp2
PHP Version: 5.1.0
-Assigned To:
+Assigned To: abies
New Comment:
Assigned to the maintainer.
Previous Comments:
[2005-11-25 11:55:38] slapaf at hotmail dot com
deleting row with "name 1" and inserting a "name 5" returns:
NULL :
string : name 3
string : name 4
string : name 5
[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 ''.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 ''.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
