• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

cacheRegion with query service?

New Here ,
Mar 11, 2020 Mar 11, 2020

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?

 

Views

320

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Mar 11, 2020 Mar 11, 2020

Copy link to clipboard

Copied

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.

 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 11, 2020 Mar 11, 2020

Copy link to clipboard

Copied

LATEST

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.

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation