> -----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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219635 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
