Nothing.....just easier to code with CFUPDATE/CFINSERT. CFQUERY using CFQUERYPARAM will help to stop SQL injection attacks, use BIND variables to increase performance (not all DBs use BIND vars), and won't bail on you all the time like CFUPDATE/CFINSERT.
Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Scott Wilhelm" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 18, 2003 12:25 PM 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
