can you test for a cached query?

[Brian Hogue]

Is there something like IsDefined that tests for a cached query? If yes, I
can use that to avoid going back to the DB. thanks in advance

-brian

[JMGibson3]

You don't have to test. Simply run the query. If the time limit has not
expired and the SQL (if you use dynamic SQL) for that query name is identical
to the last time, CF will skip the DB trip. You can turn on debugging to see
it happen, "Time=Cached Query vs. Time=141ms), BTW, to force a cache refresh,
run it with CreateTimeSpan(0,0,0,0) and if you wish (so next real user need not
suffer wait time) run it again with your normal limit.

ApplNameList (Records=32, Time=Cached Query)
SQL =
SELECT 'ALL' as ApplName, null as ApplNameSort FROM tblErrorLog
UNION
SELECT DISTINCT ApplName, ApplName as ApplNameSort FROM tblErrorLog
ORDER BY ApplNameSort