reset the timeout

[Pinan]

I am querying a large amount of data, and periodically, it does not return before it gets timed out.

How do I set the time before timeout longer?

 

[webmigit]

Set the timeout of the query to the timeout length you want, note, it is in milliseconds...

 

[Pinan]

OK, I should have been more specific. I need the syntax for it. Im kind of a newbie with cold fusion.

 

[webmigit]

<CFQUERY..attributes here..timeout=&quot;4000&quot;>...sql statement..</CFQUERY>

would set the timeout to 4 seconds.

 

[Pinan]

Thanks! Thats exactly what I was looking for.