ID: 17141
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Open
+Status: Feedback
Bug Type: ODBC related
Operating System: AIX 4.3.3
PHP Version: 4.1.2
New Comment:
Can you please provide a sample schema to reproduce this locally and
test this out further?
Previous Comments:
------------------------------------------------------------------------
[2002-05-10 09:14:03] [EMAIL PROTECTED]
I was trying to view a self-referenced Table (parent_id is the id of
another member); with OBDC towards DB2 (on AIX 4.3.3) PHP does not set
the array right; I dont get the parents name but the childs name
twice.
Code
====
$conn=odbc_connect("db", "user", "pass");
$stmt="select a.bm_id, a.bm_bezeichnung, b.bm_bezeichnung as
parent_bm_bezeichnung from schema.table a, schema.table b where
b.bm_id=a.bes_bm_id";
$res=odbc_exec($conn,$stmt);
print odbc_result_all($res);
ODBC Result
===========
BM_ID BM_BEZEICHNUNG PARENT_BM_BEZEICHNUNG
5 Tonband Tonband
6 Handy Handy
2
(the 2 is new, seems to be the "2 records selected" rest)
DB2 Result
==========
BM_ID BM_BEZEICHNUNG PARENT_BM_BEZEICHNUNG
------ -------------------- ---------------------
5 Tonband Telefonisch
6 Handy Telefonisch
2 record(s) selected.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=17141&edit=1
