Actually, it is telling you that you need to make your query return exactly
what you want.
YES, using Distinct or Unique will work, but it is not the best way to get
what you want out of the data.
Distinct is shortcut to effectively grouping your results...
or:
"The DISTINCT keyword sorts the results set in ascending order by the first
column listed in the DISTINCT list"
So it may not give you the exact answer that you are looking for every time.
In short, the repeating values are telling you to reword your query, because
you didn't ask it quite right the first time.
(This is, of course, my opinion... but it works for me.)
Heath
-----Original Message-----
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 9:19 AM
To: CF-Talk
Subject: Removing Duplicate Values in a List
I have a List that is generated from a query, How about do I remove
duplicate values within the list? I couldn't find any kind of reference to
this anywhere not even in Ben's Bible. Thanks for your help!
Jason Larson
[EMAIL PROTECTED]
406-728-4422
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
