where is the query USERS code? That is where the problem is. Anyway, add distinct or unique to it.
On Tue, 16 Apr 2002, phumes1 wrote: > 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] > >+------------------------------------------------------------------------------------+ > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
