Removing duplicates from a listbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Noble Bell - 27 Apr 2006 18:16 GMT

Hello,

Is there a quick and easy way to take a listbox of elements and search and
remove any duplicates before displaying the listbox to the user?

------------------------------------------
Noble D. Bell
AgForest Partners, Inc.

Reply to this Message

<ctacke/> - 27 Apr 2006 19:20 GMT

If it's sorted, yes, if not, then it's a process of iterating through the
list. It would be far better and simpler if you prevented duplicates when
you add the items.

-Chris

> Hello,
>
[quoted text clipped - 4 lines]
> Noble D. Bell
> AgForest Partners, Inc.

Reply to this Message

Noble Bell - 27 Apr 2006 19:32 GMT

I would love to be able to do that but my sql query will not allow me to use
DISTINCT. I have to much going on for that to work properly.

------------------------------------------
Noble D. Bell
AgForest Partners, Inc.

> If it's sorted, yes, if not, then it's a process of iterating through the
> list. It would be far better and simpler if you prevented duplicates when
[quoted text clipped - 10 lines]
> > Noble D. Bell
> > AgForest Partners, Inc.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...