Question

ASP提交表单 相同内容覆盖问题 在线等~~~~

我现在的代码是 下面这个 现在是检测 2个值 如果相同就不添加 如果不相同就添加新的记录 我想实现 如果有1个值不同就用新记录覆盖之前那个记录 改怎么写？？希望大神帮帮忙~~~~

sql="select * from list where user='" & acnt &"' and APin='" & strge &"'"
Rs.Open sql,conn,1,3

if not rs.eof then
Response.Write "Send OK"
Set rs=Nothing
Conn.Close
Set Conn=Nothing
else
Rs.AddNew

Rs("user") = acnt
Rs("pass") = pass
Rs("GServer") = serv
Rs("lock") = cate
Rs("game") = game
Rs("Time") = Now()
Rs("APin") = strge
Rs("HostIp") = request.ServerVariables("REMOTE_HOST")
Rs.Update
Response.Write "Send OK"
Set rs=Nothing
rs.close
Conn.Close
Set Conn=Nothing

end if

Answer 1

sql="select * from list where user='" & acnt &"' and APin='" & strge &"'"
Rs.Open sql,conn,1,3
if rs.eof and rs.bof then
Rs.AddNew
end if
Rs("user")=acnt
Rs("pass")=pass
Rs("GServer")=serv
Rs("lock")=cate
Rs("game")=game
Rs("Time")=Now()
Rs("APin")=strge
Rs("HostIp")=request.ServerVariables("REMOTE_HOST")
Rs.Update
Response.Write "Send OK"
Set rs=Nothing
rs.close
Conn.Close
Set Conn=Nothing