Once you have the query, just copy it: <cfset application.data = duplicate(theOriginalQuery)>
Be sure to lock if using CF < MX. ======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Bartee Lamar [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 07, 2002 2:35 PM > To: CF-Talk > Subject: application query cached HOW TO?? > > > I need to cache a query for the entire application. > > I have a set of application settings in a database table. I want to > read that table once and have it in the application scope to > be accessed > each time a new session is started. ( just like setting request > variables in application.cfm ) > > How do I do that. > > Bartee Lamar > www.enterpriseenergy.com <http://www.enterpriseenergy.com/> > MSN <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
