> 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/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:313329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
