Are you storing each user's answers separately in the db? You should be passing in an ID that relates to a given user so there shouldn't be any locking or transactions required.
Adrian Building a database of ColdFusion errors at http://cferror.org/ -----Original Message----- From: Imperial, Robert Sent: 17 November 2008 16:53 To: cf-newbie Subject: cftransaction or cflock? Hi folks, Trying to figure out or which way to handle some survey submissions here and not sure which I should be looking at, cftransaction or cflock? We want to able to have several people doing the same submission at the same tine and still insure data will be correctly tied to the corresponding id. I am working MySQL 5 on that backend, not sure if that matters but I am fairly new to this so any help (example code block?) would be greatly appreciated. TIA Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4168 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
