cacheRegion with query service?

[zpm007]

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?

[WolfShade]

Hi, zpm,

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

https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-c-d/CacheRegionNew....

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

[zpm007]

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.