Highlighted

cacheid attribute on cfquery is not working

Community Beginner ,
Jul 17, 2014

Copy link to clipboard

Copied

As per the CF10 documentation,

cacheID

Optional

ID to be used to store query result in cache. This ID can be used to either retrieve or remove query from cache

So what I have tried is simply,

<cfquery name="qryGetStudents" datasource="localdsn" cachedwithin="#createTimeSpan(1,0,0,0)#" cacheid="q1">

    SELECT    *

    FROM    student

</cfquery>

and dumped

<cfdump var="#CacheGetAllIds()#">

CacheGetAllIds() returns an array, So logically this array should contain the cache id "q1" .But I can not see that.

Anyone else faced the same?

Views

214

Likes

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

cacheid attribute on cfquery is not working

Community Beginner ,
Jul 17, 2014

Copy link to clipboard

Copied

As per the CF10 documentation,

cacheID

Optional

ID to be used to store query result in cache. This ID can be used to either retrieve or remove query from cache

So what I have tried is simply,

<cfquery name="qryGetStudents" datasource="localdsn" cachedwithin="#createTimeSpan(1,0,0,0)#" cacheid="q1">

    SELECT    *

    FROM    student

</cfquery>

and dumped

<cfdump var="#CacheGetAllIds()#">

CacheGetAllIds() returns an array, So logically this array should contain the cache id "q1" .But I can not see that.

Anyone else faced the same?

Views

215

Likes

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
Jul 17, 2014 0
BKBK LATEST
Adobe Community Professional ,
Jul 19, 2014

Copy link to clipboard

Copied

What you have discovered is a bug. You should report it at the bugbase.

Likes

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
Reply
Loading...
Jul 19, 2014 0