Finding UNIQUE items in a list...

[GregLanders]

What is the most efficient way to return a list of UNIQUE items from another list of items?

 

[pigsie]

Perhaps looping over the list sorted adding values to a second list before adding values to the second list check if the list contains the value already if not add it if it does dont add it. If you're using cf5 there may already be a UDF to do this already on

http://www.cflib.org

HTH

KOla

 

[erwino]

This should do it,

<cfloop index=&quot;item&quot; list=&quot;list1&quot;>
<cfif ListContains(list2, item [, delimiters]) IS 0>
<!--- add item to second list --->
</cfif>
</cfloop>
success