ColdFusion 8 can now use cacheAfter/cacheWithin when using cfqueryparam’s

I just noticed this in the Adobe docs for cfqueryparam in ColdFusion 8:

Revised 8/21/2007: Removed limitation on using the cfquery cachedAfter or cachedWithin attributes with cfqueryparam.This limit no longer applies.

This is great news because before (MX7 and below):

You cannot use the cfquery cachedAfter or cachedWithin attributes with cfqueryparam.

I know many people didn’t like this limitation as it meant you needed to go to extra lengths to perform query caching (such as Application scope etc).

This is another reason why CF8 is so good :)

Post a Comment or Leave a Trackback

3 Comments

  1. David Buhler
    November 1, 2007 at 3:48 am | Permalink

    Provided you have the updated hotfix:

    http://kb.adobe.com/selfservice/viewContent.do?externalId=kb402583&sliceId=2

  2. November 1, 2007 at 3:56 am | Permalink

    That link doesn’t seem to mention anything specifically in relation to caching queries using cfqueryparam, just looks like it’s a hotfix for an issue when you’re already caching queries.

    This is about a new enhancement, the ability to use these cfquery attributes when using cfqueryparam (which you couldn’t do before).

    Unless I’m mistaken and not reading the kb article correctly?

  3. Joris de Beer
    August 20, 2009 at 12:18 am | Permalink

    Weird, when I looked at the docs today, it still says:

    “You cannot use the cfquery cachedAfter or cachedWithin attributes with cfqueryparam.”

    About a quarter of a page down. And there is no other mention of cachedWithin, so perhaps Adobe have gone back on this feature/bug fix.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*