Check Dups

[emmim44]

Do you know How I will check the duplicates value and display a message in CF? I dont want to use javascript...Here is the sample select box..

<select name="Vr12H8H" id="VR#fid##b#" >

Sample result:
<select name="Vr12H8H" id="VR371" >
<select name="Vr12H8H" id="VR381" >

[Dan_Bracuk]

If you are giving your select controls id values based on a query output, write your query so that it doesn't return records.

If you want to check something for multiple occurrences, the sql is

select field1, field2, etc, count(*)
from some tables
where whatever
group by field1, field2, etc
having count(*) > 1

[emmim44]

If the db table is empty, it doesnt do work ...I need smth that will check if a one hits the submit button..it should display a message about the dups..

[Dan_Bracuk]

If the db table is empty, where are you getting your id variable from?

[emmim44]

From 2 other tables