[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