Hello. I'm sure that this has been discussed, so pointing me to a thread may be sufficient. (I looked...)
I have about 10 pages that deal with subsets of the same data, something along the lines of a list of news articles on state pages. On each state page, I'd like to list appropriate news items such that - ================== Colorado ================== News ------------------------------------ Date1 Headline1 Date2 Headline2 Date3 Headline3 And if there are more than three entries, a "more" button appears, directing the user to another page with the full listing. This is a simple query. The question is, should I: 1- Use a single (cached?) query that returns, for example, all news articles (within a date range) for all states. Then in the Colorado page I loop over the query to find the three most recent news articles for Colorado. 2- Use the query to do the heavy lifting, so that each state page submits a new query. 3 - Something completely different. TIA, Trey ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
