CFUPDATE and CFINSERT tend to let you get away with not knowing SQL. But using CFQUERY and SQL give you much greater control over your queries.
It's really a matter of preference. Personally, I won't use them. I'd rather have near complete control over my database interactions. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
