Earlier morning, I was working on creating a cached query for to display Next N record-navigation interface. I'm having the ColdFusion 8 installed in my system. The below query with CFQUERYPARAM executes well and my aim of displaying Next N record-navigation is achieved.
When testing this query in my other system having ColdFusion 7 installed I got the below error because CF 7 will not allow of using cfqueryparam in cfquery with cachedWithin/cachedAfter.
The great news is ColdFusion 8 allows cachedWithin/cachedAfter in cfquery with cfqueryparam and this is one of the hidden gems of ColdFusion 8. But in CF8 documentation which is not having the updated information about this functionality.
CFML/Web/Mobile/Salesforce/Agile Enthusiast, Husband & Dad, an avid Technology, Android fan and creator of GetCFMLJobs.com. Currently working as a Sr.Consultant & TPM in Phoenix, Arizona.