Hello,
I'm trying to determine if a record exist before I insert a record. Can anyone point me in the right direction here??
Heres how my code looks right now with nothing checking for duplicate records. An example or code snippet would really help and be appreciated.
<%
Dim name, email, country, sql_insert
name= request.form("name")
email = request.form("email")
country = request.form("country")
'Connection String is here
sql_insert="insert into users (name, email, country) values ('"& name &"','"& email &"', '"& country &"')"
con.execute sql_insert
con.close
Set con = Nothing
%>
I'm trying to determine if a record exist before I insert a record. Can anyone point me in the right direction here??
Heres how my code looks right now with nothing checking for duplicate records. An example or code snippet would really help and be appreciated.
<%
Dim name, email, country, sql_insert
name= request.form("name")
email = request.form("email")
country = request.form("country")
'Connection String is here
sql_insert="insert into users (name, email, country) values ('"& name &"','"& email &"', '"& country &"')"
con.execute sql_insert
con.close
Set con = Nothing
%>