[thelist] Netscape Only error using CF and Oracle *

[Raymond K. Camden]

Turn on query debugging in your CF Admin, run the query in Netscape and
check what SQL is getting sent to the backend.

=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Allaire

Email   : jedimaster at allaire.com
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda


> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Howell, Katie
> 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 !