I tried that earlier and the results come out as: total=2 for page1; total=2 for page1; total=1 for page2. It groups by pagename first then by username, resulting in a bunch of little groupings which isn't what we want.
We need it to come out as total=2 for page1; total=1 for page2. In other words, we'd like to see pagenames grouped and sorted by pagename with unduplicated usernames making up the count() aggregate. --steve ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
