Have you managed to get the SQL statement that runs when it falls over? What
does it look like?
Adrian
-----Original Message-----
From: Jason Fill
Sent: 08 August 2007 15:26
To: CF-Talk
Subject: ColdFusion 8 & CachedWithin Issue
I am getting very strange behaviors while using CachedWithin on CF8. All
the sudden, something that has been working without fail for months in CF7
is giving odd errors. On CF8 I will get intermittent errors that say
"corrupt table null". If I remove the cachedwithin attribute the query runs
fine. For example, I can pass in the state argument of AL and it works
fine, but when I pass in CO it blows up. Any thoughts?
<cfquery name="qGetStates" datasource="#Variables.Settings.DSN#"
cachedwithin="#CreateTimeSpan(0,12,0,0)#">
SELECT State,StateName,Country,TimeZone,BorderingStates
FROM dbo.States
WHERE 0=0
<cfif len(trim(Arguments.State))>
AND State = '#trim(Arguments.State)#'
</cfif>
<cfif len(trim(Arguments.TimeZone))>
AND TimeZone = '#trim(Arguments.TimeZone)#'
</cfif>
<cfif len(trim(Arguments.ExcludeCountries))>
AND Country NOT IN ('#trim(Arguments.ExcludeCountries)#')
</cfif>
ORDER BY #trim(Arguments.OrderBy)#
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285690
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
