Let's say I put a query like below in a CFC: <cfquery name=" news_menu" datasource="#dsn#" cachedwithin="#createTimeSpan (0,0,20,0)#"> SELECT <cfif select_limit gt 0>TOP #select_limit# </cfif> 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; </cfquery> Sometimes I want a short menu so I set select_limit to a number to limit the query results. Sometimes I want a complete menu so I set select_limit to 0 to get all results. If this is in a CFC will it always work on each page correctly if they send different select_limit values from different pages? If so, does it still make since to cache the results? Thanks, Robert
Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 <http://www.austin-williams.com/> http://www.austin-williams.com Great advertising can't be either/or. It must be &. Plug in to our blog: A&W Unplugged <http://www.austin-williams.com/unplugged> http://www.austin-williams.com/unplugged ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335942 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
