well, you would not gain the esteem of your peers here for sure!! LOL! Best to roll your own SQL.
Doug >-----Original Message----- >From: Scott Wilhelm [mailto:[EMAIL PROTECTED] >Sent: Tuesday, March 18, 2003 3:26 PM >To: CF-Talk >Subject: Benefits of Using <CFUPDATE>/<CFINSERT> (was RE: NOT >A CRITICAL >ISSUE - <CFUPDATE> vs <CFQUERY> UPDATE tablena me e tc.) > > >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
