[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