I am using a primary key Primary Key ID Data Type = AutoNumber Field Name alert Data Type = Text
The database is not updating. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu slaba...@po-box.esu.edu -----Original Message----- From: Robert Bailey [mailto:cft...@tropicalbean.com] Sent: Thursday, December 18, 2008 3:15 PM To: cf-talk Subject: Re: Simply Amin Panel I am guessing you are not using a primary key. I think your cfif is a little off, try this <cfquery datasource="text"> UPDATE alert SET alert = <cfif IsDefined("FORM.alert") AND len(FORM.alert)>'#FORM.alert#'<cfelse>NULL</cfif> WHERE alert = '#FORM.alert#'; </cfquery> <cflocation url="../../status1.cfm?msg=Alert+Title+added+successfully."> </cfif> Thanks! Robert Bailey Steve LaBadie wrote: > Is this correct? I am not getting any errors, but the updated text is > not showing on the page. > > <cfquery datasource="text"> > UPDATE alert > SET alert = '<cfif IsDefined("FORM.alert") AND #FORM.alert# NEQ "">' > WHERE alert = '#FORM.alert#'; > <cfelse> > NULL > </cfif> > </cfquery> > <cflocation url="../../status1.cfm?msg=Alert+Title+added+successfully."> > </cfif> > > Steve LaBadie, Web Manager > East Stroudsburg University > 200 Prospect St. > East Stroudsburg, Pa 18301 > 570-422-3999 > http://www.esu.edu > slaba...@po-box.esu.edu > -----Original Message----- > From: Ravi Gehlot [mailto:r...@ravigehlot.net] > Sent: Thursday, December 18, 2008 1:59 PM > To: cf-talk > Subject: Re: Simply Amin Panel > > Hello Steve, > > You want to update and not insert if you want to replace the text. > > Good Luck, > Ravi Gehlot. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
