I believe this can occur if the uncached query failed to complete for any
reason. CF apparently will think it was cached, but of course it will have
no results available. I have seen this occur on a server when a
particularly long-running query is still executing to go into the cache at
the same time another request comes in for the cached version. (My guess is
that CF marks a query as cached when it begins to execute rather than when
it has completed, but I don't know this for certain.)
There is some discussion of this issue in the CF forums on Allaire's web
site.
You can use <cftry> and <cfcatch> around the query code to trap this error
and submit the query without asking for an available cached version.
There may be other explanations, but this is the only one I am familiar
with.
-----Original Message-----
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 1:00 PM
To: CF-Talk
Subject: Cached Query! Was Working Yesterday!
CFQuery Retrieval of cached query failed
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (39:1) to (40:43).
This is the entire message. Why would it do this? It was working
yesterday, I went live with it, now it's failing. I'm going insane!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists