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

Reply via email to