我用asp往数据库里添加1条记录, 但是它自动添加了两条, 如何解决这个问题?
我用asp往数据库里添加1条记录, 但是它自动添加了两条, 如何解决这个问题?
代码如下:
<%
if request("content")="" or request("content")=null or request("plz")="" or request("plz")=nill then
Response.Write"<script language=JavaScript>"
Response.Write"alert(""不能发表空评论."");"
Response.Write"window.location.href='"&request.servervariables("HTTP_REFERER")&"'"
Response.Write"</script>"
response.end
end if
grade = int(request("grade"))
if not isNumeric(grade) or grade < 1 or grade > 5 then
grade = 3
end if
%>
<!--#include virtual="func/initconn.asp"-->
<%
Set rs = Server.CreateObject("ADODB.recordset")
sql="select * from pl"
rs.open sql,conn,1,3
rs.addnew
rs("leixin") = session("wzlx")
rs("ourid") = request("id")
rs("content") = request("content")
rs("plz") = request("plz")
rs("riqi") = now()
rs("ifview") = "不显示"
rs("grade") = grade
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<script language=JavaScript>
alert("评论发布成功!");
window.location.href="<%=request.servervariables("HTTP_REFERER")%>;"
</script>