Im generating a summary report but the current method Im using could result in up to 100 queries or more...so this is what Im trying to achieve.
Basically dealing with two fields, Carrier and Date. The user selects a date range, I need a count all the records for each day within the range grouping by the Carrier. Currently I create a list of Carrier's then loop thru, within the loop I CFQUERY and get counts for each carrier for that single day (inner loop), well this results in tons of queries....and could potentially be really slow depending on the date range although I limit to 31 days. Output needs to look like this: CARRIER DATE1 DATE2 DATE3 carr1 n n n carr2 n n n carr3 n n n carr4 n n n Any recommendations on how to speed this up with perhaps a single query? and if thats possible how would I CFOUTPUT to get the above results. Thanks! Adrian ______________________________________________________________________ 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
