We have a case where it appears our template is running twice - but only intermittently. We did a SQL Profile/Trace and noticed two calls to the stored proc on the page, for one page request (us clicking the form submit button only once). We also added some logging capabilities to the stored proc involved here and saw something like this:
SP Starting SP Starting SP Processing SP End SP End (notice the SINGLE processing line) This again was would occur on a single page submission. We tested this by going through the page submission routine a number of times, and sometimes it works as expected and others causes this problem. Any ideas? We do take into account concurrency via a where clause like this "Where Last_Updated = @LastUpdated AND ..." (with proper date conversions and such). Then check to see if @@RowCount is zero - which would indicate a concurrency issue, and failed update. The error we are getting seems to indicate the concurrency issue - however, our data does get updated. And checking the SQL Trace shows two calls to the SP occasionally which indicates the template is executing twice. If we are getting the concurrency error, BUT our data is updated, then the page seems to be running, updating the data, then running again, and then failing. So, I'm looking for ideas on how this situation could occur, and how to resolve it. We are running CF5 on Win2K with a SQL 2000 back end. Thanks for any input. Shawn Grover (my appologies for the rambling description). ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
