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
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
