Cfquery timeout parameter.

2007-02-22 Thread Ian Skinner
Can somebody tell me exactly how this works? Reading the documentation I get this message. Timeout: 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. What exactly is an action in a query and if

RE: Cfquery timeout parameter.

2007-02-22 Thread Ben Nadel
? www.bennadel.com/ask-ben/ -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 12:38 PM To: CF-Talk Subject: Cfquery timeout parameter. Can somebody tell me exactly how this works? Reading the documentation I get this message. Timeout: Maximum

RE: Cfquery timeout parameter.

2007-02-22 Thread Ian Skinner
I guess it means the execution of a single: UPDATE SELECT DELETE Would this also apply to sub-selects and other more comlex SQL syntax? Say: SELECT aField FROM (SELECT bField FROM bTable) aTable Would that be two actions? Each one allowed to run for the timeout period, or if the inner select

RE: Cfquery timeout parameter.

2007-02-22 Thread Ben Nadel
] Sent: Thursday, February 22, 2007 12:52 PM To: CF-Talk Subject: RE: Cfquery timeout parameter. I guess it means the execution of a single: UPDATE SELECT DELETE Would this also apply to sub-selects and other more comlex SQL syntax? Say: SELECT aField FROM (SELECT bField FROM bTable) aTable