CFquery cachedwithin

vksrinu wrote: I have custom page for all the query executions. to the custom page i am sending the db credentials and  cachedwithin parameter. i am checking what will happen  if i set the timespan to 0,0,0,0 (which is default in the code). for all the queries the query name is same,so will that take same data results for all the queries. is there any option as no cache in cfquery. ex: i am executing a query where it will take the control id for increment. i am executing this many no of times will this take the same results or will it fetches the data each time from the database when i given the cachewithin as 0,0,0,0.

I am assuming you are passing the value of the cachedWithin variable dynamically, and wish to know the value of cachedWithin for which the query wont be cached (all other variables remaining the same). The secret is to realize that createTimeSpan() returns a number of days. Thus, createTimespan(0,0,30,0) is equal to approximately 0.02083. That is, 30 minutes is approximately 0.02083 days.

Now, let us suppose the variable you are dynamically passing for cachedWithin is cachedPeriod.

<cfquery cachedWithin="#cachedPeriod#">

Then you can be sure the value cachedPeriod=1 will cache for 1 day, cachedPeriod=0.25 for 6 hours, and so on. If you set cachedPeriod to 0 or to a negative number, the query wont cache.

If you set the CACHEDWITHIN to a timespan of 0, it will not cache the query and will reexecute the query each time.

If your query's SQL statement differs each time it is executed, CFQUERY will reexecute the query each time also, although the results of the previous execution will have been cached. Cached results are only used if the datasource, connection string, and SQL are identical.

Dave Watts, CTO, Fig Leaf Software