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

From: Date: Mon, 10 Jul 2006 11:45:38 +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-99293@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:

Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php
for *NIX and
http://bugs.php.net/bugs-generating-backtrace-win32.php
for Win32

Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.




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

[2006-07-10 11:24:50] john dot enevoldson at pulsen dot se

Hi,
Have installed php5.2-latest.tar.gz but now get a segmentation fault
during the connect processing,
Regards,
John.

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

[2006-07-10 09:41:59] tony2001@php.net

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?

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

[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 (#99293) next »