Then one I have not seen mentioned yet is a page timeout. By default a CF thread will only wait 60 seconds for a page to resolve, your query taking 90 seconds will exceed this. Have you taken steps to allow the page to wait long enough for the stored procedure to finish? I.E. settings in the administrator globally or the <cfsetting ...> tag locally.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
