Skip to main content
E
emmim44
Inspiring
January 26, 2007
Question

Check Dups

  • January 26, 2007
  • 4 replies
  • 302 views
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" >
This topic has been closed for replies.

4 replies

E
emmim44Author
Inspiring
January 26, 2007
From 2 other tables
D
Dan_Bracuk
Inspiring
January 26, 2007
If the db table is empty, where are you getting your id variable from?
E
emmim44Author
Inspiring
January 26, 2007
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..
D
Dan_Bracuk
Inspiring
January 26, 2007
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
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices