Perhaps use SQL CONTAINS? Identify a common character set for each br owser type and count records containing that string.
Tony -----Original Message----- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Friday, February 01, 2002 12: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 tryin g 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 poss ible, 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 ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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
