[thelist] Netscape Only error using CF and Oracle *
Herzog, Ari
Ari_Herzog at Instron.com
Mon Nov 20 13:12:05 CST 2000
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 !
More information about the thelist
mailing list