Just a simple series of multiple choice question responses being submitted to an insert recording their answers along with the id. Then at the end doing a js pop confirmation and a cflocation to hit the confirmation/thank you page.
Bob -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2008 12:13 PM To: cf-newbie Subject: RE: cftransaction or cflock? Not really. Unless you're doing something out of the ordinary. Are you doing something like: Form page with questions, answers and patientID >> post to an action page >> store the answers with associated patientID for the assciated question. Adrian -----Original Message----- From: Imperial, Robert Sent: 17 November 2008 17:05 To: cf-newbie Subject: RE: cftransaction or cflock? Yes a patient Id is being stored but is there a possibility if say 4 or 5 people are hitting it at the same time for data to be mismatched? -----Original Message----- From: Adrian Lynch Sent: Monday, November 17, 2008 12:00 PM To: cf-newbie Subject: RE: cftransaction or cflock? 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:4171 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
