SELECT color ,COUNT(*) AS colorCount FROM ShoeTable GROUP BY color M!ke
-----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, June 21, 2007 11:12 PM To: CF-Talk Subject: RecordCount and Sub(?) Counts? I can think of all kinds of evil "use a loop" and stuff to do this, but what's a more compact way, or is there one? Stupid Example - a query that returns shoes 100 total shoes returned (shoeQUERY.recordcount) How can I get the query to also tell me there's 45 red shoes, 15 blue shoes and 40 green shoes without doing dome kind of loop with a counter outside the query? Or can you? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
