Actually, I was wrong -- even <cfsetting requesttimeout="1" enablecfoutputonly="No"> doesn't work, because it still waits for the cfquery to finish before it outputs the timeout error. Is there any solution for this? The database we're relying on is unstable and we need to be able to kill the query sooner.
Thanks, - Sung > Here's my test: > > <cfquery name="test" datasource="dsn" timeout="1"> > select top 20000 * > from table > </cfquery> > <cfoutput>#cfquery.ExecutionTime#</cfoutput> > > I'm getting 3000+ for this value. This shouldn't be, right? Because > I have the timeout parameter set for a second? The driver I'm using > is the one that's supplied with CFMX7.02, "Microsoft SQL Server". > > The only way I can make this work is if I use <cfsetting > requesttimeout="1" enablecfoutputonly="No">, but I don't want to do > that. What is going on? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:321590 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4