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?
On Mon, Jul 26, 2010 at 3:12 PM, Ian Skinner <[email protected]> wrote: > At this time, the Insert is done with a simple <cfquery...> call BEFORE > the <cfstoredproc...> call. That is the way the stored procedure was > created over a decade ago. For the first phase of this project, we are > only updating the application server level of this process. It waits > for a future phase to tackle the stored procedures in the database > level. And let me tell you that is a project we both desire and dr ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:335739 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
