小小的问题又出现了?在添加完数据后 加什么代码能解决下面问题??

[msq847]

<%
dim rs,con,Query
set con=Server.CreateObject("ADODB.Connection")
con.open="Driver={SQL SERVER};Server=FILESERVER;Database=OA;UID=sa;PWD=kschina918;"
set rs=server.CreateObject("ADODB.Recordset")
Query="select * from jlb_xmrw"
rs.open Query,con,1,3

rs.addnew
rs("cpmc")=request("scpmc")
rs("cpbh")=request("scpbh")
rs("gdml")=request("sgdml")
rs("bbh")=request("sbbh")
rs("xdrq")=request("sxdrq")
rs("xdr")=request("sxdr")
rs("jdyq")=request("sjdyq")
rs("xmfzr")=request("sxmfzr")
rs("gnms")=request("sgnms")
rs.update
rs.close
con.close
set rs=nothing
set con=nothing
response.write "<script language=JavaScript>" & chr(13) & "alert('信息添加成功！');"&" history.back();</script>"
%>

返回指定的页面呢??
那添加相同的编号 怎么能让他提示出来报错

[nevsong]

response.redirect "url"

[煊烨]

response.write "<script language=JavaScript>" & chr(13) & "alert('信息添加成功！');"&" location.href='你要去的地址';</script>"
－－
select * from jlb_xmrw where 编号字段=‘需要添加的编号字段’

if not rs.eof then
报错
else
添加
end