I had a feeling it was something like that but I wanted to make sure. Thanks,
Howie ----- Original Message ----- From: "Haggerty, Mike" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 04, 2002 4:17 PM Subject: RE: Query caching > Here's an example on CF 4.5: > > <CFQUERY NAME="senate" DATASOURCE="resource"> > SELECT lastname, firstname, party, state, website, email > FROM senators > WHERE state = '<CFOUTPUT>#session.state#</CFOUTPUT>' > </CFQUERY> > > <cfset session.temp = senate> > > <CFOUTPUT>#session.temp.recordcount#</CFOUTPUT> > > -----Original Message----- > From: Howie Hamlin [mailto:howie@;coolfusion.com] > Sent: Monday, November 04, 2002 4:15 PM > To: CF-Talk > Subject: Query caching > > > I have an application where I would like one or two queries cached during a > session. I know that you can use > cachedwithin to cache a query globally for an application but I don't think > that would be based on session... > > So, is it possible to cache a query for a session? If so, a small code > example would be appreciated. > > Thanks, > > -- > Howie Hamlin - inFusion Project Manager > On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 > inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server > >>> Find out how iMS Stacks up to the competition: > http://www.coolfusion.com/imssecomparison.cfm > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
