Makes sense. Clearly, if you were testing for "ID = '#myVar#'", then the
number of variances would make caching irrelevant, but it sounds like this
case might be a good candidate.
~|
Order the Adobe Coldfusion Anthology now
her [mailto:ja...@wanax.com]
Sent: Tuesday, August 03, 2010 2:52 PM
To: cf-talk
Subject: re: CFC Query Question
Well, that code will create a separate cache for each version of the
variable query statement.
Cf
http://forums.devshed.com/coldfusion-development-84/cfml-cfquery-cachedwithi
n-do
Well, that code will create a separate cache for each version of the
variable query statement.
Cf
http://forums.devshed.com/coldfusion-development-84/cfml-cfquery-cachedwithi
n-does-changing-order-by-create-new-query-680793.html
In other words, I think it will work the way you expect.
Let's say I put a query like below in a CFC:
SELECT TOP #select_limit# safelink, news_id,
headline, description, pub_year, pub_month, pub_day
FROM tbl_news
ORDER BY pub_year DESC, pub_month DESC, pub_day DESC, headline;
Sometimes I want a short menu so I set select_limit to a number to l
4 matches
Mail list logo
