[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