Removes the query with the details you provide from query cache.

removeCachedQuery(SQL_, datasource, params, region___); → returns void

This function requires Adobe ColdFusion 10 and up.  Not supported on Lucee, etc.

Argument Reference

SQL string

The Query SQL.

datasource string

The datasource you ran the query on.

params array

Array of parameter values passed to SQL.

region string

Specifies the cache region where you can place the cache object.

Sample code invoking the removeCachedQuery function

the in-memory file system memory set in cfadmin and should return that.

<cfset sql = 'SELECT * from art where artid = ?'> 
 <cfquery name='q' datasource='cfartgallery' cachedwithin='#createTimespan(0, 6, 0, 0)#'> 
 SELECT * from art where artid = <cfqueryPARAM value = '1' CFSQLType = 'CF_SQL_INTEGER'> 
 <cfset a = arrayNew(1)> 
 <cfset a[1] = 1> 
 <cfset removeCachedQuery(sql,'cfartgallery', a)> 

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub