I'm not sure I understand your circumstances, but if one user has siteID=20 and another one has siteID=123, the query below will cache 2 record sets.
Happens all the time at www.SMARTERyellowpages.com (MANY cached queries there) best, paul At 01:24 PM 1/16/03 -0500, you wrote: >Ok, I've been reading up on query caching today and I think I've run >into something that may cause me problems unless there is a way to >dynamically name queries. > >I have an application that houses data for multiple "sites" - the data >is referenced by a siteID that is set as a session variable. > >So for example: > ><cfquery datasource="#request.dsn#" name="qGetSite"> >SELECT sitename >FROM tblSites >WHERE siteID=#session.siteID# ></cfquery> > >If I try to cache this query, then if someone logs in with a siteID of >20 then they'll get their data, unless the query is cached, then they'll >get the data of whoever logged in the last time - no matter what their >siteID correct? > >Is there a way to create a dynamic queryname? > >I tried: <cfquery datasource="#request.dsn#" >name="qGetSite#session.siteID#"> and it worked to create the query, but >for subsequent references I'm getting errors like on: > >This errors: <cfif qGetSite#session.siteID#.recordcount GT 0> >This errors: <cfset queryct="qGetSite#session.siteID#.recordcount"> > <cfif evaluate(queryct) GT 0> > >Is there a way I can dynamically name my query so that I can use query >caching without giving users the wrong data? > >Can I turn off all query caching and then specify queries to cache using >the CACHEDWITHIN statement for queries that don't rely upon the siteID? > >Thanks, > >Joshua Miller >Head Programmer / IT Manager >Garrison Enterprises Inc. >www.garrisonenterprises.net <http://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 ><mailto:[EMAIL PROTECTED]> >[EMAIL PROTECTED] >************************************************************************ >************* > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
