removeCachedQuery

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

removeCachedQuery(SQL_, datasource, params, region___);

This function requires Adobe ColdFusion. Not supported on Lucee, OpenBD, etc.

removeCachedQuery Argument Reference

SQL
Required

The Query SQL.

datasource
Required

The datasource you ran the query on..

params

Array of parameter values passed to SQL.

region

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

Examples sample code invoking the removeCachedQuery function


Tag Syntax

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'> 
 </cfquery> 
 <cfset a = arrayNew(1)> 
 <cfset a[1] = 1> 
 <cfset removeCachedQuery(sql,'cfartgallery', a)> 

Fork me on GitHub