Use "DISTINCT" in your query
Bob -----Original Message----- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 10:01 AM To: CF-Talk Subject: Re: LOOP Hi, The below lists all users logged in to the server. If the user has logged in more than once then I get multiple usernames listed. How can I only list one occurrence of all users? <cfoutput query="USERS"> #User# </cfoutput> The above outputs: Administrator Administrator Administrator Administrator test test user1 user1 user2 user3 user3 I want to display only: Administrator test user1 user2 user3 +--------------------------------------------------------------------------- --------+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +--------------------------------------------------------------------------- ---------+ ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
