1 Reply Latest reply: Jul 19, 2014 6:18 AM by BKBK RSS

    cacheid attribute on cfquery is not working

    Deepak Kumar Padhy Community Member
    Deepak Kumar Padhy Jul 17, 2014 8:48 AM

      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?