You could use group by Select Count(browsertype) as bcount, browsertype >From yourTable Group By browsertype
______________________ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Friday, February 01, 2002 3:55 PM To: CF-Talk Subject: browser version count I have a table that I keep track of page views on a couple pages and I am grabbing the browser tag of the user who visits the site. I am trying to get it to display the number of each distinct browser hit the page(s). Was just wondering if anyone had some code to figure this out already, or if I would need to write some ColdFusion to parse through each row in the query and keep track that way. Would prefer to do the count in SQL if possible, can't just use DISTINCT because that doesn't split it out by browser version, just by browser tags. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ______________________________________________________________________ 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
