Firstly, install MS Fiddler and examine the HTTP requests being sent from your browser when you click whatever button or link loads the processing page. All too many times I have seen a form with a submit button AND a JavaScript onclick that are working together to submit the form more than once. Again, a product such as SeeFusion will also make it easier to see if the proc is running twice as part of the same request or once in two separate requests.
If the request is only being sent from your browser once, than step through the fuse action begin called and examine your CF debugging to see how many times everything is being called. I'm sure there's a logical explanation somewhere but you're the only one that can do the leg work to find it. You don't by chance have your cfstoredproc call in a custom tag do you? Self-closing tag calls like <cf_myproc /> used to run twice- once with executionmode=start and once for end.1 As far as the SQL error-- what is the data type of you primary key field and how are you generating the primary key values? As far as the fact that the proc would error on either the 0 or 1 is mostly meaningless and up to chance if the problem is a concurrency issue. If the proc cannot allow a concurrent execution, it will be up to the luck of the draw as to which one errors first. ~Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329651 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
