#35386 [Opn->Asn]: first row is null

From: Date: Wed, 11 Jan 2006 13:47:15 +0000
Subject: #35386 [Opn->Asn]: first row is null
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-91767@lists.php.net to get a copy of this message 
 ID:               35386
 Updated by:       tony2001@php.net
 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] tony2001@php.net

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 '<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

Thread (29 messages)

« previous php.bugs (#91767) next »