#38054 [Opn->Fbk]: PDO with db2 returning column names but not data

From: Date: Mon, 10 Jul 2006 09:41:59 +0000
Subject: #38054 [Opn->Fbk]: PDO with db2 returning column names but not data
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-99287@lists.php.net to get a copy of this message 
 ID:               38054
 Updated by:       tony2001@php.net
 Reported By:      john dot enevoldson at pulsen dot se
-Status:           Open
+Status:           Feedback
 Bug Type:         PDO related
 Operating System: SLES 9.3 64 bit
 PHP Version:      5.1.4
 New Comment:

Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.2-win32-latest.zip

What does var_dump($row); show, btw?


Previous Comments:
------------------------------------------------------------------------

[2006-07-10 06:31:42] john dot enevoldson at pulsen dot se

Description:
------------
We are seeing column names returned but no associated data when issuing
selects against a db2 data source using pdo:odbc (bulit with the ibm-db2
option). DB2 trace shows that data is being returned to the application
correctly but the application does not seem to pick it up. 

Reproduce code:
---------------
$dbh = new PDO('odbc:zdb2lt01' , 'db2tst01', 'adg680');
   foreach ($dbh->query('SELECT * from PXX.XPRMFOK') as $row) {
     print_r($row);
   }

Expected result:
----------------
A array for each row in the table showing column name and associated
data.

Actual result:
--------------
A array for each row in the table showing column name but associated
data is empty.


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=38054&edit=1

Thread (9 messages)

« previous php.bugs (#99287) next »