给你个参考的例子
set rs=server.createobject("adodb.recordset")
sql="select * from [表] where date=#"&request("date")&"# and hm='"&request("hm")&"'"
rs.Open sql,conn,1,3
if rs.eof=false then
response.write"<script>alert('对不起!你输入的数据已存在,返回操作!');"
response.write "javascript:history.go(-1)</SCRIPT>"
response.end
end if
rs.addnew
rs("date")=request("date")
rs("hm")=request("hm")
rs.update
rs.Close
set rs=nothing