But that doesn't work when you do: Query#ID#.RecordCount
I can get it to generate the query, just not call it ... It's moot point though, I was an idiot in my thinking that the query name had something to do with the cache :) It's actually the QUERY and not the NAME that the cache is based on - DUH! Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ************************************************************************ ************* Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] ************************************************************************ ************* -----Original Message----- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 6:02 PM To: CF-Talk Subject: RE: Macromedia TechNote on Database Performance QUERY="MyQuery#ID#" best, paul At 05:04 PM 1/16/03 -0500, you wrote: >I'm having luck just changing some queries to Stored Proceedures ... >I'd like to use caching, but I can't figure out a way to specify >dynamic query names. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
