PHP4 Oracle SELECT statement ERROR

From: Date: Wed, 18 Sep 2002 18:04:29 +0000
Subject: PHP4 Oracle SELECT statement ERROR
Groups: php.general 
Request: Send a blank email to php-general+get-116784@lists.php.net to get a copy of this 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 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

« previous php.general (#116784) next »