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)> 

Fork me on GitHub