r 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 and timeout or how I can override it?