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.
To explore more about CF 8 Hidden Gems please check Charlie Arehart's presentation on Hidden Gems in ColdFusion 8 PDF and his recorded Adobe Connect Presentation.
CFML/Web/Cloud/Data/Agile Enthusiast, Husband & Dad, an avid learner & android fan who works as a Tech Consultant in Toronto, Canada.
ColdFusion 2021 Tutorials (New)
Get Your Next CFML Job! ColdFusion Tuts
ColdFusion Tutorials & Resources
Adobe Agile AppCore Creator BlogCFC Books Bootstrap CFBuilder CFEclipse CFML Chennai CFUG Chrome Extensions ColdFusion Google IIS India Learning MySQL Railo Subversion Tools & Utilities Web Windows 7
2021 2018 2017 2016 2014 2013 2012 2011 2010 2009 2008