CF Admin query time setting

[cleanair4me]

For CF MX 7 the CF admin setting for database queries timeout is set at 100. Because of this some of my queries timeout and give me back a timeout message.

I am trying to overwrite it in my cfquery working with Oracle 9i:

<cfquery datasource="cityOra" timeout="300" name="queryOne">
select * from mainTable
</cfquery>

It still gives me timeout message after 100 seconds no matter what I have in the cfquery timeout. Please advise why this is not overriding the CF Admin timeout or how I can override it?

 

[FALCONSEYE]

can you try?

<cfsetting requesttimeout="300"> before your query

http://www.fuzzysiberians.com