Quoting "Burcham, Steve" <[EMAIL PROTECTED]>: > What is the best way to 'kill' a cached query on a logout sequence?
The only way that I know of to kill a cached query is to run the query with cachedwith set to one second. If there's a better way, I'd *love* to hear about it. (There are cachedwithins all over my website set for like 10 days but every few months when I update the site I have to go through the code and reset the cachedwiths to one second, then hit every page in the site.) By the way, I tried to set a request variable to put in cachedwithin so I could change it in only one place instead of every query in the site. It was not happy. It just dawned on me that maybe I have to put PreserveSingleQuotes() around it to make it work. Does anybody know before I go breaking my site? But if you are doing it on a logout, it seems like maybe you really want the query to exist in the session, not in the cache. If you store the query in a session, it'll die on logout or when the session times out. -- If you hate the interface, blame Kevin. ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
