Question

求教ASP插入数据库如某字段相同提示有重复如何写？

<%
Conn.Execute("INSERT INTO biao(title,tentent,ip,tel) Values('" &title& "','" &tentent& "','" &ip& "','" &tel& "')")

rs.close
set conn=nothing
response.redirect"index.asp?action=logo"
Response.End
%>
如提交的tel数据和数据库有重复就提示信息

Answer 1

If conn.Execute("Select tel From biao Where tel='"&tel&"'").Eof
Conn.Execute("INSERT INTO biao(title,tentent,ip,tel) Values('" &title& "','" &tentent& "','" &ip& "','" &tel& "')")
rs.close
set conn=nothing
response.redirect"index.asp?action=logo"
Response.End
Else
Response.Write("电话号码重复")
End If

Answer 2

set rs=cnn.execute("select * from Zhuce where user='"&user&"' ")
if not rs.eof then
'已存在
else
'不存在 insert
end if
set rs=nothing

回答别人的直接贴过来了，自己入下SQL