很简单的问题,帮忙瞧瞧!回答的满意在加分!这是第二贴了,如果回答好的,分数都给他
下面是我最新改的程序,现在的问题是无论我是否确认覆盖,都在数据库中新添加一条记录,但是我在确认覆盖时执行的是UPDATE啊,这是为什么啊?
set rss=conn.execute("select count(*) as Recount from bbsb_bbxx where d_dwbm='"&dwbm&"' and d_sbwjm='"&varFileName&"'")
j=rss("Recount")
if j=0 then
rec.Open "SELECT * FROM bbsb_bbxx where d_id is null",conn,1,3
rec.addnew
rec("d_sbwjm")=varFileName
rec("d_sbwj").appendchunk mydata
rec("d_sbqj_nf")=nf
rec("d_sbqj_yf")=jd
rec("d_dwmc")=dwmc
rec("d_dwbm")=dwbm
rec("d_sslj")=sslj
rec("d_sbsj_rq")=sbsj_rq
rec("d_id")=newid
rec("d_sbsj_sj")=sbsj_sj
rec.update
rec.close
else
%>
<script language="javascript"> //判断是否确认覆盖
var agree = confirm("确认是否覆盖?");
if (agree){
<%
set rs2=conn.execute("update bbsb_bbxx set d_sbwj='"&mydata&"',d_sbsj_sj='"&sbsj_sj&"' where d_dwbm='"&dwbm&"' and d_sbwjm='"&varFileName&"'")
%>
alert("已覆盖")
}
else{
<%
rec.Open "SELECT * FROM bbsb_bbxx where d_id is null",conn,1,3
rec.addnew
rec("d_sbwjm")=varFileName
rec("d_sbwj").appendchunk mydata
rec("d_sbqj_nf")=nf
rec("d_sbqj_yf")=jd
rec("d_dwmc")=dwmc
rec("d_dwbm")=dwbm
rec("d_sslj")=sslj
rec("d_sbsj_rq")=sbsj_rq
rec("d_id")=newid
rec("d_sbsj_sj")=sbsj_sj
rec.update
rec.close
%>
alert("未覆盖")
}
</script>
<%
end if
set rec=nothing
set conn=nothing
%>