This content has been marked as final. Show 4 replies
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
group by field1, field2, etc
having count(*) > 1
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..
If the db table is empty, where are you getting your id variable from?
From 2 other tables