[thelist] Netscape Only error using CF and Oracle *
Daniel J. Cody
djc at five2one.org
Mon Nov 20 13:53:57 CST 2000
Katie -
Shot in the dark, but try making your sql statement(and maybe even CF
vars) lowercase. This is a really wack problem, so lets try some wack
solutions :)
Lemme know if that works.. Also, turn on debugging if you can and post
the SQL that CF is sending to oracle
.djc.
Howell, Katie wrote:
> 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>
>
More information about the thelist
mailing list