Hi, I need to check a database for double entry on name and surname… For example, the same person can’t enter the competition. This is my code… Whats wrong?
rstotal.Open "Select COUNT(*) as total from comptbl WHERE cname='" & Request("name") & "' and csurname='" & Request("surname"), conn
Please help.
Thanks!
Its actually a sql question… oops. sorry…