right but my result of the query could be 134 135 135, 134 134, 135, 2 so the result is distinct. so when it puts them into a list i get 134, 135, 135, 134, 134, 135, 2
i am going to to try to look at list to array? and then back to list? On Tue, May 13, 2008 at 11:57 AM, Andy Matthews <[EMAIL PROTECTED]> wrote: > If you're doing a distinct in your query, or a group by, then you > shouldn't > have any dupes. > > -----Original Message----- > From: morchella [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 13, 2008 10:47 AM > To: CF-Talk > Subject: Re: easy one! : comma separated list from cfoutput > > awsome... > thank you! > > now.. =] > how would i remove doubles? > > <!--- List of Accessory's that are assigned to this product ---> <cfquery > name="getAccessory" datasource="listit"> SELECT DISTINCT ascList FROM > dbo.list WHERE (specs_partnum IN (#columns#)) AND (ascList IS NOT NULL) > </cfquery> > > gives me... > > ascList > 132 > 135 > 135,132 > > so my list looks like > aclist: 132,135,135,132 > > just want 132,135 > > thanks again! > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305175 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4