After upgrading to ColdFusion 10 I noticed that the error
timeToLive can't be negative is thrown for each query that was cached for more than 15 days.
This bug is already reported in the Adobe’s Bugbase: Error when using CFQUERY’s cachedWithin with value > 15 days
A quick workaround is to cache the query for less than 15 days; like that:
<cfquery name="myQuery" datasource="#dsn#" cachedwithin="#CreateTimeSpan(15,0,0,0)#">
Starting to understand the frustration of the people commenting on the last ColdFusion 11 update: blogs.coldfusion.com…
… the current state of affairs is not good enough anymore in 2014. To be honest it already wasn’t good enough anymore in 2011 or 2012. You need to get your processes under control. … If your build and test process for CF is too cumbersome to do faster releases, it seriously needs to change or you’ll end up like the dinosaurs a few 100 million years ago — you’re trying to compete with modern web technology stacks/frameworks there and there should be an update every 4-6 weeks.
Update: a few hours after I wrote this, the status of the bug changed to ‘Fixed’ – as the CF 10 Update 14 was released.
Written by Dorin Moise (Published articles: 229)