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
