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:281872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
