Thank you for your comments.
<cfif NOT isdefined("session.temp")>
<cflock name="data_6" throwontimeout="Yes" timeout="10"
type="EXCLUSIVE">
<cfif NOT isdefined("session.temp")>
<CFQUERY NAME="senate" DATASOURCE="resource">
SELECT lastname, firstname, party, state,
website, email
FROM senators
WHERE state = '#session.state#'
</CFQUERY>
<cfset session.temp = senate>
</cfif>
</cflock>
</cfif>
<CFOUTPUT>#session.temp.recordcount#</CFOUTPUT>
Happy now?
Hoping I did this right,
M
-----Original Message-----
From: Raymond Camden [mailto:jedimaster@;macromedia.com]
Sent: Monday, November 04, 2002 4:33 PM
To: CF-Talk
Subject: RE: Query caching
This example is missing locking. Sorry if I sound like a broken record -
but you _must_ remember to use locking. Also, you don't need cfoutputs
in cfquery tags - CF vars are automatically processed.
=======================================================================
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Get the mailserver that powers this list at http://www.coolfusion.com
