Check for duplicate entry

[kinjiro]

I have a page that pulls a column from an access DB.
This column could appear on my webpage any number of times dependant on how many entries there are in the DB.

What I need to do in javascript is loop through each field checking for duplicate entries.

The name of the field is in the format "order_" & IDfromDB

I can do everything apart from the detecting of the duplicate entry. Unfortunately the IDfromDB will most likely NOT be sequential, so I need to code for that.

Any ideas?

[u2orange]

Are you removing the duplicate entries?

If so (not sure if access can do this, but possible with SQL) why not alter your query to the table with:

SELECT DISTINCT ...

HTH
u2o

[Webforumz Staff]

Are you using Javascript for ASP? If not I'm not sure why you'd be doing this on the client-side verses the server-side as that's the correct place to do filtering like this (either in the SELECT like u2 said or in writing the recordset to the page).