[thelist] Netscape Only error using CF and Oracle *

Howell, Katie Kathleen.Howell-1 at ksc.nasa.gov
Mon Nov 20 13:20:49 CST 2000


we don't use cfupdate.....we write all queries in SQL

-----Original Message-----
From: Herzog, Ari [mailto:Ari_Herzog at Instron.com]
Sent: Monday, November 20, 2000 2:12 PM
To: 'thelist at lists.evolt.org'
Subject: RE: [thelist] Netscape Only error using CF and Oracle *


I may be mistaken, but try this instead:


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

I believe you need a new SET tag.
Also, do you want UPDATE or CFUPDATE?


------------------------------------
Ari Herzog
Internet Webmaster
Instron Corporation
Tel:  781-575-5638
Fax: 781-575-5768
Email: ari_herzog at instron.com

Check out our website at http://www.instron.com


-----Original Message-----
From: Howell, Katie [mailto:Kathleen.Howell-1 at ksc.nasa.gov]
Sent: Monday, November 20, 2000 1:52 PM
To: thelist at lists.evolt.org
Subject: [thelist] Netscape Only error using CF and Oracle *


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

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt ! 

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt ! 




More information about the thelist mailing list