Nat, Thank you, it showed me a whole new approach. However, now I need to know how to output the results in this manner:
Brazil 5 USA 90 Thanks, simon -----Original Message----- From: Plane, Nathaniel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 2:18 PM To: CF-Talk Subject: RE: dynamic query try the following query, thats all you should need, that way you dont have to loop over a recordset. select count(*) as TheCount, b_country from connreporting group by b_country order by b_country ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
