[thelist] Netscape Only error using CF and Oracle *

Raymond K. Camden rcamden at allaire.com
Mon Nov 20 14:52:15 CST 2000


You say that your problem occurs when you try to ADD data, but, you got a CF
error in the SET area. Maybe there is a logic flaw in your code? Before your
CFIF, try adding:

<CFOUTPUT>Add = #Add#</CFOUTPUT>

and make sure that the value is being passed. By the way, if you are using
URL parameters, you _really_ need to specify that. Ie, don't use Add, use
URL.Add.

=======================================================================
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 3:45 PM
> To: thelist at lists.evolt.org
> Subject: RE: [thelist] Netscape Only error using CF and Oracle *
>
>
> 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.
>
>
> ---------------------------------------
> 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