Also phumes1, if you cannot do that for some reason, see the "group" and "groupCaseSensitive" attributes of the CFOUTPUT tag.
-Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com ----- Original Message ----- From: "Bob Imperial" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 9:59 AM Subject: RE: LOOP > 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] > +--------------------------------------------------------------------------- > ---------+ > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
