<%
set rs=oconn.execute("select * from table where code='" & request("code") & "'")
if not rs.eof then
response.write "<script>alert('号码已存在');history.go(-1)</script>"
end if
%>
<%
code=request.form("code")
set rs=server.createobject("adodb.recordset")
sql="select * from table where code='"&code&"'"
rs.Open sql,application("cn"),3,1
if not rs.eof then
response.write "<script language=JavaScript>{window.alert('号码存在');window.location.href='*.asp';}</script>"
response.end
end if
%>
Dim rs
Set rs = Server.CreateObject("Adodb.RecordSet")
rs.open "select code from table where code='"&request("code")&"'",conn,1,3
If Not rs.eof Then
response.write "已经存在!"
End If
rs.close
Set rs = nothing
<%
set rs=oconn.execute("select * from table where code='" & request("code") & "'")
if not rs.eof then
response.write "<script>号码已存在</script>"
end if
%>