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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285678
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
