He might also mean the execution plan. Adrian
-----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 01 October 2008 16:24 To: cf-talk Subject: Re: Clearing out the query cache > unfortunately their not, it's the server's query cache that has them, > is it possible to force them to not cache in the first place (without > setting the query cache setting in the CF server to 0) Are you saying they're cached within the Server scope, and you reference them as Server.yourqueryname? If so, you can manage them just like you would any other variable. You can delete them using StructDelete, or overwrite them. The query cache setting in the CF Administrator affects queries cached with CACHEDWITHIN/CACHEDAFTER. CF doesn't cache queries automatically. You must either use CACHEDWITHIN/CACHEDAFTER or place your queries in Session, Application or Server variables. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
