Hi all.
I am making a Insertpage with a dynamic listmenu. The values in the listmenu comes from a table from the database, however I get all the values returned to the listmenu. What I want is for it to ignore a value if it already exists and jump to the next one.

MeZ...

in the sql code in your recordset you need to add the word DISTINCT that will remove duplicates.

Example

Select DISINCT yourlabel
FROM yourTable

Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

Thanks Vince!

MeZ