Thread: Query Time
View Single Post
•
•
Join Date: Nov 2007
Posts: 34
Reputation: chicago1985 is an unknown quantity at this point 
Solved Threads: 0
chicago1985 chicago1985 is offline Offline
Light Poster

Query Time

 
0
  #1
May 18th, 2008
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?
Last edited by chicago1985; May 18th, 2008 at 8:40 am.
Reply With Quote