I have also noticed that when I retreive values from a view into an
associated array I will not get the proper name of the field. 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

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

I will 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?

"Notoriousvic_ca" <[EMAIL PROTECTED]> wrote in message
> Hi I am a programmer and I just started using PHP4.
> I created a view in Oracle (code below) and I added an underscore to the
> of one of the column names ("id_number_").
> When I use asp code to select from this view I have to write a select
> statement like so:
> "Select * from view_specimen_details where id_number_=1"
> However when I use PHP4 with OCI8 I get an error when I try to execute the
> above statement. Although if I remove the underscore of the variable in
> where clause everything works.
> "Select * from view_specimen_details where id_number=1"
> I cannot change the view. Does anyone have a workaround for this problem?
> Thanks in Advance
> -- Create view
> create or replace view view_specimen_details
>  as SELECT           a.ID_NUMBER        id_number_,
>   FROM  catalogue

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

Reply via email to