You have to remove the dupes before you loop over the list On Wed, May 21, 2008 at 3:57 PM, morchella <[EMAIL PROTECTED]> wrote:
> all that seems to do is to remove the commas? > > <cfoutput query="getAce" group="title"> > #title# x<br /> > <cfloop From = "1" To = "#ListLen(getAce.specs_partnum)#" index = > "Counter"> > <cfoutput group="specs_partnum"> > <cfset acccL = #ListGetAt(getAce.specs_partnum,Counter)#> > <cfset acccL = '#acccL#,'> > #ListDeleteDuplicates(acccL)# > </cfoutput></cfloop> <br /><br /> > </cfoutput> > > Cable Management x > 9969593, 9969593, 9969599, 9969599, 9969594, 9969594, 9969600, 9969600, > 9969599, 9969599, 9969601, 9969601, 9969600, 9969600, 9969928, 9969928, > 9969601, 9969601, 9969927, 9969927, 9969928, 9969928, 9969597, 9969597, > 9969927, 9969927, 9969736, 9969736, 9969597, 9969597, 9969595, 9969595, > 9969736, 9969736, 9969598, 9969598, 9970253, 9970254, 9970255, 9970256, > 9970263, 9970264, 9970265, 9970266, 9970271, 9970271, 9970271, 9970271, > > Cable Management x > 9969593 9969593 9969599 9969599 9969594 9969594 9969600 9969600 9969599 > 9969599 9969601 9969601 9969600 9969600 9969928 9969928 9969601 9969601 > 9969927 9969927 9969928 9969928 9969597 9969597 9969927 9969927 9969736 > 9969736 9969597 9969597 9969595 9969595 9969736 9969736 9969598 9969598 > 9970253 9970254 9970255 9970256 9970263 9970264 9970265 9970266 9970271 > 9970271 9970271 9970271 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:305852 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4