Is there a way, without having to write separate queries for each instance, to list the number of records sorted by a specific field?
For example, I've got a table of products listed by a number of countries. On one page, I'd like a summary: US 12 products found INDIA 23 products found ITALY 10 products found. There's close to 40 countries in the database. Certainly don't want to put 40 queries on one page just to count the number for each country! What's "Best Practice" here? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4