cacheRegion with query service?

In CF10, is there a way to set the cache region when using cfscript query functions?

For example:

sqlString = 'select * from dual';

qs = new query();
qs.setName('testME');
qs.setcachedwithin(createTimespan(0,0,5,0));

qs.setAttributes('cacheRegion', 'users'); //This doesnt seem right?

This topic has been closed for replies.

Legend

Hi, zpm,

I've never used cacheRegion, but did a quick Google search and found:

You learn something new, every day. I had no idea one could cache according to region. HTH.

Participant

Thanks but that only creates a region for other objects when using cacheput. It doesnt apply the region to the query service object.

Im looking for the equilvant of cfquery tag based to syntax to this:

<cfquery... cacheRegion="test">

select * from dual

</cfquery>

In this example, it creates the region if it does not exist.

Sign up