You don't need those hashes in the CFSETs. Can't fully answer your question, but have a look at the ISOLATION attribute of CFTRANSACTION for a start.
>Hi. I have a database table with a single row and following columns: > >TotalMembers >RegisteredToday >NewestMember > >I update this row everytime someone registers. My question is, how >should i control simultaneous updates/locking/unloking issues? > >Please help. Here's what i am doing right now: ><cftransaction> > <cfquery> > UPDATE db_sitestats > SET TotalMemembers = TotalMenbers+1, > RegisteredToday = RegisteredToday+1... > </cfquery> > > <cfquery name="getstats"> > Select * from db_sitestats > </cfquery> > > <cfset application.TotalMembers = #getstats.TotalMembers#> > <cfset application.RegisteredToday = #getstats.RegisteredToday#> ></cftransaction> > >Please tell if i need to do anything else. These Stats are always >shown on the homepage of the site. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
