What's the best way to clear out a cached query, so that your
production site will use the most current database information? I want
to retain my long cache spans on a production box, but I want to be
able to "update" or "refresh" the queries at will.
Here is my current process:
1. Break the connection (give the datasource a faulty path/name) in
the administrator.
2. Hit the template in a browser.
3. Repair the broken connection in the CF administrator.
4. Hit the page again. The query is updated/re-cached.
I don't like this method, because it is awkward, and it momentarily
affects the production site. Is there a better way?
Thanks,
Jamie
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
