[thelist] Netscape Only error using CF and Oracle *

[Howell, Katie]

One quick update....The form that is passing the info is used for adding
records or updating them, depending on what the user wants to do.  The error
occurs when I'm trying to add a record.  Here's the code for the save page:

<CFIF ID IS "ADD">
<cfquery name="insert" datasource="webuser">
INSERT INTO IMAR_PROJ ( 
	PROJ_NAME,
	DESCRIPTION
	)
VALUES (
	'#PROJ_NAME#',
	'#DESCRIPTION#'
	)
</cfquery>
<CFELSE>
<cfquery name="Update" datasource="webuser">
UPDATE  IMAR_PROJ
SET  	PROJ_NAME ='#PROJ_NAME#', 
		DESCRIPTION ='#DESCRIPTION#'
WHERE   PROJ_ID = #ID#
</cfquery>
</CFIF> 

The debuggings shows that it's trying to update a record with the PROJ_ID of
"ADD".  When the add button is selected, ID="ADD" is passed via this
javascript:

<a href="javascript:show('A','ADD')"><img
src="/sgs/common/images/buttons/btn_add.gif" width="71" height="26"
border="0" alt=""></a>

So the save.cfm template should know that the value of ID = ADD.  

Thanks for your suggestions....I'm gonna think on this a bit and tackle it
again in the AM

Katie

-----Original Message-----
From: Daniel J. Cody [mailto:djc at five2one.org]
Sent: Monday, November 20, 2000 2:51 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] Netscape Only error using CF and Oracle *


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.