Yes - use the "Group" attribute of <CFOUTPUT> First make sure your list is ordered by the field you want to group by (OrderID) and then <cfoutput query="blah" group="OrderID"> <cfoutput>#OrderID#</cfoutput> </cfoutput> This will output each unique OrderID just once > -----Original Message----- > From: HappyToad.com [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, October 03, 2000 7:47 AM > To: CF-Talk > Subject: Eliminate duplicates?? > > Question: > I have built a store app and orders are stored with each product ordered > being assigned its own table row but sharing the unique order id. How can > I > have a query that will display the order ids without duplicates? Is there > a > way to eliminate duplicates without limiting the output rows? > > Thanks, > Rich > > -------------------------------------------------------------------------- > ---- > Archives: http://www.mail-archive.com/[email protected]/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
