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

Reply via email to