TryCF Gist

trycf-gist.cfm

<cfscript>
people = queryNew("id,name,mail,showtime", "integer,varchar,varchar,timestamp", [
    [1, "weed", "weed@theflowerpot.not", now()],
    [2, "bill", "bill@theflowerpot.not", now()],
    [3, "ben", "ben@theflowerpot.not", now()]
]);


writeDump(var=people, label="initial");

cacheAfterThis = dateAdd("s", 2, now());

peopleToCache = queryExecute(
    "SELECT * FROM people",
    [],
    {dbtype="query", people=people, cachedAfter=cacheAfterThis}
);
writeDump(var=peopleToCache, label="to cache");

sleep(5000);

peopleFromCache = queryExecute(
    "SELECT * FROM people",
    [],
    {dbtype="query", people=people, cachedAfter=cacheAfterThis}
);

writeDump(var=peopleFromCache, label="from cache");
</cfscript>