Can anyone give me an idea how to handle concurrent updates when using CFQUERY?
What we normally do in a stored procedure is to add the LastUpdate date/time value to the where clause, then check the @@RowCount to see if zero rows were affected (if so, then it's a good bet the date changed, which means someone else has updated the record), and then either raise a SQL error, or return a specific value to be intercepted with CFStoredProc.StatusCode. However, we are in a situation where stored procs are not being used. And with CFQuery, we can't use return codes, and even doing multiple updates is troublesome (having to use SET NOCOUNT ON/OFF). So, I'm looking for ideas. I think we have a method to handle it, but want to see what others are doing for this situation. Thanks. Shawn Grover ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
