On 7/26/2010 4:26 PM, Maureen wrote: > Sounds more like a timing issue with the actual execution of the code > on the database. Can you check the success of the insert before > calling the stored proc?
As noted in an earlier post, it was a commit issue. The insert in the <cfquery...> was not being committed. And the stored procedure being called in the <cfstoredproc...> was waiting for it to be committed. Adding a <cftransaction...> to explicitly commit the insert allowed the process to work as desired. I've just never had to do that before. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335747 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
