cfquery cache stores failed queries

[Wilgeno]

cfquery cache still stores failed queries. This was reported years ago
([url]http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?catid=6&threadid=8[/url]
58673&highlight_key=y&keyword1=cache is the earliest report I can find)

Still no fix from Macrobe. Has anyone found a suitable work around. BTW:
setting the cache timespan to createtimespan(0,0,0,0) failed to clear the query
from the cache. I was only able to clear the query from cache by removing the
cachedwithin attribute. That is not a valid work around.



<cftry>
<cftransaction isolation="READ_COMMITTED">
<cfquery name="getStyles" datasource="#application.datasource#"
cachedwithin="#CreateTimeSpan(0,4,0,0)#">
SELECT DISTINCT Style
FROM Properties
WHERE
ISNULL(Style,'') != ''
ORDER BY
Style
</cfquery>
</cftransaction>
<cfcatch type="Database">
<cfinclude template="/mlsfindershared/__error_message.cfm">
<cfinclude template="/mlsfindershared/__error_email.cfm">
</cfcatch>
</cftry>

[Kevin Schmidt]

Any chance you could load the query into an application scope variable as the method of caching?