On Sun, 8 Feb 2004 10:46:15 -0400, "Thierry B." <nospam@nospam.com> wrote:
[color=blue]
>I will use alias, but I already used integer indexing, the buffer returned
>by oracle simply miss one column[/color]
Unique identifiers for each column within a result set is certainly the way to
go, but just testing out whether it does lose data:
<pre>
<?php
$conn = OCILogon('test', 'test', 'dev92lnx');
$stmt = OCIParse($conn, 'select 1 id, 2 id from dual');
OCIExecute($stmt);
OCIFetch($stmt);
echo "OCIFetch:\n";
echo OCIResult($stmt, 1) . "\n";
echo OCIResult($stmt, 2) . "\n";
echo OCIResult($stmt, "ID") . "\n";
echo "\nOCIFetchInto:\n";
OCIExecute($stmt);
OCIFetchInto($stmt, $row, OCI_ASSOC+OCI_NUM);
var_dump($row)
?>
</pre>
Outputs:
OCIFetch:
1
2
1
OCIFetchInto:
array(3) {
[0]=>
string(1) "1"
["ID"]=>
string(1) "2"
[1]=>
string(1) "2"
}
The second identically named column isn't lost. Most of the PHP OCI8 functions
work using bind by name, rather than position, but the data is still there.
If you fetch into an associative array by name, clearly it can only keep one
of the values. (Although this could be better documented - can't spot a
reference from a quick read through). And the code above shows an inconsistency
between OCIResult and OCIFetchInto as to which one it picks in the case of
identical identifiers (which is almost certainly a bug).
--
Andy Hassall <andy@andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>
