Copy link to clipboard
Copied
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?
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.