Question
cacheid attribute on cfquery is not working
As per the CF10 documentation,
| 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?
AdChoices