Thanks Jim. This is some good insight. I am trying out some tests right now, I'll let you know what the results are in a little bit.
Jim Davis wrote: >>-----Original Message----- >>From: Jim Davis [mailto:[EMAIL PROTECTED] >>Sent: Thursday, September 29, 2005 12:05 PM >>To: CF-Talk >>Subject: RE: ways to cache a query other than 'cachedwithin' >> >>I think there might be some confusion here... you're "cfif" statement >>isn't >>doing what I think you think its doing. ;^) >> >>When you cache a query using cachedwithin it caches the query results >>keyed >>to the SQL statement (and information about it like user and password) - >>it >>doesn't cache the VARIABLE you're using however. Essentially if you run >>that EXACT SQL again you'll get the cached results. > > > Now I'm not so sure about that... but I think I'm still right. > > The queryname is definitely used as part of the key to the cached data... > but since it's not in a permanent scope I don't see how it could be > available to be checked (using IsDefined()) until the query is run. > > I think this needs some testing... > > Jim Davis > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219638 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
