On Tue, Apr 14, 2009 at 5:25 PM, Sung Woo <s...@cornell.edu> wrote: > > Hi Casey, > > What happened today is that the SQL server basically locked up. CF kept > waiting for the request to come back, but it never did because it just hung > infinitely. It seems as if CF waits forever in a case like this, so it's > vital that I can kill the connection from the CFQUERY. >
That's totally separate issue. if sqlserver is locking up, coldfusion is waiting to make a connection, not getting the result back. the timeout on cfquery only works on the actually sql statement itself. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4