>Can you get a test page into production? > >You might need to find out if its only this stored procedure that is timing >out. > >Can you run a conventional query that does the same thing and test it?
I can not get a test page onto production. I know that it's running half way through the page fine because data is updated in those update sql scripts. After that, there's a bunch of if/else statement. The first thing in each of those if/else statements is this stored procedure. There is information that should be updated after that stored procedure, none of which are being updated. This led me to the stored procedure as the possible culprit. Still, what is the expected action of the page if the stored procedure times out? I know I can set a timeout to a query, but not to a stored procedure. If it does time out, what happens to the rest of the cold fusion page? I'm trying to determine the reason that the rest of the fields aren't being updated. thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6929 Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-server/unsubscribe.cfm
