Not show same values if they exist

[billy_111]

Hey,

If i have this code:

                <select id="AvailableTourCodes" multiple="multiple">
                    <%
                    Do While Not Rec.EOF
                        %>
                        <option value="<%=Rec(0)%>"><%=Rec(1)%></option>
                        <%
                        Rec.MoveNext
                    Loop
                    %>
                </select>

Which gives this result:

<option value="88664">RHMA811</option>
<option value="88673">MAGA711</option>
<option value="88674">MAGA711</option>
<option value="88674">MAGA711</option>
<option value="88681">MRCAM11</option>
<option value="88684">NYA5D11</option>
<option value="88690">GFA1211</option>

I want to remove the duplicates, now i can't do this via the SQL because of the way it has been setup, it will cause problems elsewhere.

So what i want to do it try and looop through and remove the duplicates so the result is this:

<option value="88664">RHMA811</option>
<option value="88673">MAGA711</option>
<option value="88681">MRCAM11</option>
<option value="88684">NYA5D11</option>
<option value="88690">GFA1211</option>

Is this possible?

Kind regards,

[billy_111]

I figured it out. I declared a variable and set the value or the recordset to that. Then i checked to see if the values matched, if so i didnt display the <option>.

[itHighway]

You may also use DISTINCT in your sql query.