What would I gain by using CFUPDATE/CFINSERT over CFQUERY? THanks,
Scott > -----Original Message----- > From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 18, 2003 2:24 PM > To: CF-Talk > Subject: RE: NOT A CRITICAL ISSUE - <CFUPDATE> vs <CFQUERY> UPDATE > tablena me e tc. > > > What database were you using? Oracle has known problems with > CFUPDATE and > CFINSERT. > > -----Original Message----- > From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 18, 2003 2:19 PM > To: CF-Talk > Subject: NOT A CRITICAL ISSUE - <CFUPDATE> vs <CFQUERY> > UPDATE tablename e > tc. > > > I was going absolutely bonkers not understanding why <CFUPDATE> wasn't > always updating a field consistently, so I switched to <CFQUERY> and > updating the fields with SQL commands and it's now working > perfectly. I > wasn't using any session or client variables other then those > passed from > the form, but this one field (critical, of course) wasn't > always updating > using <CFUPDATE>. Sometimes it would and sometimes it > wouldn't. Hitting > the refresh button a few times would occasionally update the > field. Has > anyone else come across something like that? TIA, Keith > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4