Remove dup entries in a list box

[Kendel]

Hi there,

Can someone please show me how to remove duplicate entries in a listbox before I save them to the DB.

Many Thanks.

-kendel

 

[YNOTU]

Is it safe to assume that your populating the list box from a database?

if so

use select Distinct * from table....

 

[Kendel]

Yes, the list is populated from DB. But user can also add more items to this list from another list.

thanks.

 

[sharedworld]

You can do it programaticly by storing the values in an array, and then on each row of the database you should check if it's not in the array (do while...).

But actually you can use the distinct function in SQL, here you have information about that

http://www.sql-server-performance.com/nb_select_distinct.asp

 

[Kendel]

Yes I did use 2 different 'distinct select's to populate items into 2 lists. Then I let users move items from 1 list to another. When they done with movinf items around, there might be some dups in the lists. I want to remove the first before saving.

 

[sharedworld]

the best thing would be to check it with javascript onSubmit, I can workaround on a function for you if you wish

 

[Kendel]

Thanks sharedword. Before submitting the page, I want to call a script function to remove the dup in the box but I don't know how write it. If you know how, please kindly show me.

Many thanks.

-kendel

 

[sharedworld]

please first show me the an example of your select bow where you need the function to be done

 

[Kendel]

Something like this:

<form name="form1" method="post" action="me.asp">
<Table>
   <tr>
     <td>
        <Select name="List2" size="5" mutiple>
            <%While not RsData.EOF%>
            <option value="<%=RS("id")%>">
                 <%=Rs("Name")%>
            </option>
            <% RS.MoveNext
               Loop
             %>
         </select>
      </td>
      <td><input type="button" value="Save" onclick="RemoveDupe();">
    </tr>
</table>
</form>