Update queries do not return anything, so coldfusion is probably having a tough time caching a variable that doesn't exist...
> -----Original Message----- > From: Steve Brownlee [mailto:[EMAIL PROTECTED] > Sent: Friday, December 01, 2006 3:33 PM > To: CF-Talk > Subject: CFMX 7.0.2 and CachedAfter > > 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:262508 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
