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 [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 end > 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 the > 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