[PHP-DB] PHP4 OCI8 SELECT from view BUG

[notoriousvic_ca]

 Hi I am a programmer and I just started using PHP4.
I have noticed that when I retreive values from a view into an
associated array using OCI8, I array will not carry the correct field name

For example if I create a view like :

create or replace view view_specimen_details
    as SELECT a.ITEM_CLASS "order",
           a.FIELD2         "scientific name",
           a.FIELD16        "common name",
    FROM  catalogue a

Then execute a select statement like so :
@ocifetchinto($stmt,&$result[],OCI_ASSOC)

Then I will iterate through the array :

 foreach ($resultSet[0] as $fN => $fV)
 {
        echo $fN;
        echo $fV;
        echo "<br>";
 }

I get :
ITEM_CLASS [value]
FIELD2   [value]
FIELD16 [value]

What I want is :
order [value]
scientific name [value]
common name [value]

Does anyone have a work around?




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php