UC知道asp conn.execute自动执行了两次
来源：百度知道 编辑：UC知道 时间：2024/05/15 08:17:37
<%
reid = request.QueryString("reid")
if reid <> "" then
reid = cint(reid)
end if
set rsCompanyInfo = server.createobject("adodb.recordset")
rsCompanyInfo.open "select cName from companyInfo where uId = "&reid,conn,1,1
if act = "s" then
mailBody = RePlaceExp(trim(request.form("mailBody")))
mailTitle = trim(request.form("mailTitle"))
conn.execute("insert into cMailBox(receiveId,sendId,mailTitle,mailBody) values("&reid&","&uId&",'"&mailTitle&"','"&mailBody&"')")
end if
%>
每次都自动插入了两条记录，烦死了
最后搞ASP，觉得它真的是垃圾透了，不时就出个莫名其妙的错
reid = request.QueryString("reid")
if reid <> "" then
reid = cint(reid)
end if
set rsCompanyInfo = server.createobject("adodb.recordset")
rsCompanyInfo.open "select cName from companyInfo where uId = "&reid,conn,1,1
if act = "s" then
mailBody = RePlaceExp(trim(request.form("mailBody")))
mailTitle = trim(request.form("mailTitle"))
conn.execute("insert into cMailBox(receiveId,sendId,mailTitle,mailBody) values("&reid&","&uId&",'"&mailTitle&"','"&mailBody&"')")
end if
%>
每次都自动插入了两条记录，烦死了
最后搞ASP，觉得它真的是垃圾透了，不时就出个莫名其妙的错
楼上幽默，RP问题啊
局部无用 要看全部 act=s if只执行一次插入。。所以我要看全部。
错误都是人为的,如果你认为asp"出个莫名其妙的错"的就是"垃圾透了",不知道是ASP的错误,还是你自己的错误
看看你的页面是否提交了两次,是否执行了两次SQL语句
任何错误都是有原因的,不可能因为你的RP有问题,ASP才出个错忽悠你