Recently updated an application that uses cached queries to the 7.0.2
updater. Took me forever to find out what was causing this because the
compiler was directing me to the wrong line number for what was causing
the error. Here's the query that is causing the problem -
<cfquery name="getFirstRecord" datasource="#request.avars.DB#"
cachedAfter="#dateAdd("d", 1, now())#">
UPDATE messageQueue
SET messageHint = 4,
receivedDate = sysDate,
parameters = parameters ||
';recvmach=#preserveSingleQuotes(Application.Vars.ComputerName)#'
WHERE rowID = '#recordRowID#'
</cfquery>
This, then, produces the following error -
java.lang.ClassCastException: coldfusion.runtime.Struct
at coldfusion.tagext.sql.QueryTag.setupCachedQuery
(QueryTag.java:696)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:492)
I'm admittedly not a big user of cached queries. Only use them when I
feel it's absolutely necessary, and that's been rare. I've re-read the
docs a few times today and I can't really figure out anything about this
query that would cause such a mysterious error.
Have any of you stumbled across problems with cached queries since the
7.0.2 updater?
Gracias in advance,
Steve Brownlee
http://www.fusioncube.net/
(which is currently down due to violently high winds in my area)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262507
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
