If you can't do this, try these UDFs:

http://www.cflib.org/udf.cfm?ID=532

http://www.cflib.org/udf.cfm?ID=533


>>> [EMAIL PROTECTED] 20/06/2003 16:07:51 >>>
Only put unique value in the list in the first place.
Always best to fix the problem at it's source if you can.

Phil.

----- Original Message ----- 
From: "Knott, Brian" <[EMAIL PROTECTED]>
To: "CFAussie Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, June 20, 2003 4:01 PM
Subject: [cfaussie] Unique values


> If I have a list or array, what's the best way to get the unique values
out
> of it.  ie is a list contain 1,2,1,3 I just want the unique values 1,2,3
>
>
>
> Brian Knott
> QANTM Studio
> Senior Database Developer
> Ph (07) 30174331
> Mob 0407572127
>
>
> ---
> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] 
> To unsubscribe send a blank email to
[EMAIL PROTECTED] 
>
> MX Downunder AsiaPac DevCon - http://mxdu.com/ 
>


---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED] 
To unsubscribe send a blank email to [EMAIL PROTECTED] 

MX Downunder AsiaPac DevCon - http://mxdu.com/

-------------------------------------------------------
Maddocks

Tel: (03) 92880555   International: +61 3 92880555
Fax: (03) 92880666   International: +61 3 92880666

Web: http://www.maddocks.com.au

-------------------------------------------------------
The information in this electronic mail is privileged
and confidential, intended only for use of the individual
or entity named.  If you are not the intended recipient,
any dissemination, copying or use of the information is
strictly prohibited.  If you have received this transmission
in error please delete it immediately from your system
and inform us by email on [EMAIL PROTECTED]
-------------------------------------------------------


---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/

Reply via email to