The group attribute did the trick. THanks
At 10:06 AM 4/16/2002 -0400, you wrote: >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
