A CFQUERY can have multiple SQL statements in it and the timeout is applied to each statement. The timeout is passed to the DB and is the DB's issue, not CFs issue. This means that if the driver for the DB does not support timeouts being passed, the timeout attribute is pointless. I'm still trying other things, but....
>I've had mixed results with that. From the docs : > >"Maximum number of seconds that each action of a query is permitted to >execute before returning an error. The cumulative time may exceed this >value. > >For JDBC statements, ColdFusion sets this attribute. For other >drivers, check driver documentation." > >I have yet to understand what is "each action of a query". The >timeout does work, its just not always as expected though. We use >Oracle exclusively, dunno about other RDBMS. > >DK > >On 9/22/05, Michael Dinowitz <[EMAIL PROTECTED]> wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219064 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
