#27203 [Fbk->Csd]: Querying database columns with name HIDE fails to get data
ID: 27203
User updated by: jakob at grimstveit dot no
Reported By: jakob at grimstveit dot no
-Status: Feedback
+Status: Closed
Bug Type: OCI8 related
Operating System: RedHat 9.0
PHP Version: 4.3.4
New Comment:
Closing.
As cjbj at hotmail dot com states: The HIDE column was found as an
other column in the same query, thus being a problem (not a bug) with
the way the assoc arrays handles multiple columns with same name.
Sorry if I didn' report this with enough data for you to study.
Will this be implemented in a better way later?
Previous Comments:
------------------------------------------------------------------------
[2004-02-10 21:13:19] cjbj at hotmail dot com
With respect to the filer, (i) this bug contains no reproducible PHP
code (ii) no table descriptions (iii) no sample data.
However from looking at the very little information available, the
data at http://www.starshipping.com/~jakobbg/datafound.txt
shows both
a HIDE column and a TYGGEGUMMI column. The HIDE column in
datalacking.txt has the same data as the datafound.txt HIDE column.
The datalacking.txt results are probably due to selecting two columns
called HIDE from two tables e.g. as t1.hide and t2.hide. When doing
this and using associative arrays, only one column is returned by PHP.
There are a couple of recent user comments in
http://www.php.net/manual/en/function.ocifetchinto.php
talking about
this. The solution I added there recently is to use column aliases.
Given how PHP associative arrays do not include a table name
qualifier, I'd say this isn't a bug.
------------------------------------------------------------------------
[2004-02-10 17:54:22] sniper@php.net
Nobody is asking you to _install_ the snapshot, you can just as easily
run the script with CLI..do NOT touch this report before you're giving
the asked feedback.
------------------------------------------------------------------------
[2004-02-10 09:24:02] jakob at grimstveit dot no
Will do this as soon as possible. Creating a SuSE9 vmware installation
and will compile apache and php with same options as on the rhl9-box
used here. Can't deploy into same place since this is a prod-server :-)
------------------------------------------------------------------------
[2004-02-10 08:04:23] sniper@php.net
Please try using this CVS snapshot:
http://snaps.php.net/php4-STABLE-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php4-win32-STABLE-latest.zip
------------------------------------------------------------------------
[2004-02-10 05:09:58] jakob at grimstveit dot no
About "Reproduce code": Actual SQL is shown in URL's described in
"Actual result" area. Sorry about that.
------------------------------------------------------------------------
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/27203
--
Edit this bug report at http://bugs.php.net/?id=27203&edit=1
Thread (7 messages)