[thelist] Netscape Only error using CF and Oracle *

Howell, Katie Kathleen.Howell-1 at ksc.nasa.gov
Mon Nov 20 12:51:55 CST 2000


I have a coldfusion application with an Oracle 8 backend.  On a certain page
if using netscape I get this error:

Diagnostics:
Oracle Error Code = 921 
ORA-00921: unexpected end of SQL command 

The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (15:1) to (15:44).

Runs fine in IE, and everyone has looked at my SQL and can't find the
"unexpected end".  
Here's the SQL

<cfquery name="Update" datasource="webuser">
UPDATE  IMAR_PROJ
SET  	PROJ_NAME ='#PROJ_NAME#', 
		DESCRIPTION ='#DESCRIPTION#'
WHERE   PROJ_ID = #ID#
</cfquery>

Have anyone ever run into this?

Thanks,

Katie




More information about the thelist mailing list