注册 登录
编程论坛 ACCESS论坛

求教高手,我的代码错在哪?谢谢!

szwda 发布于 2013-02-22 10:42, 1664 次点击
程序代码:
<!--#include file="hezi.asp"-->
<%
dim sjid,bjid,wgid,cdid,qingsjia,qingbjia,wugu,chidao,sql
sjid=Split(request("sjid"),",",-1,1)
bjid=Split(request("bjid"),",",-1,1)
wgid=Split(request("wgid"),",",-1,1)
cdid=Split(request("cdid"),",",-1,1)
qingsjia=request("qingsjia")
qingbjia=request("qingbjia")
wugu=request("wugu")
chidao=request("chidao")
if qingsjia>0 then
for i=0 to qingsjia-1
dim strSQL
strSQL="UPDATE yinyuehe SET sjshu=sjshu+1 where id="&sjid(i)

else if qingbjia>0 then
for i=0 to qingbjia-1
dim strSQL
strSQL="UPDATE yinyuehe SET bjshu=bjshu+1 where id="&bjid(i)

else if wugu>0 then
for i=0 to wugu-1
dim strSQL
strSQL="UPDATE yinyuehe SET wgshu=wgshu+1 where id="&wgid(i)

else if chidao>0 then
for i=0 to chidao-1
dim strSQL
strSQL="UPDATE yinyuehe SET cdshu=cdshu+1 where id="&cdid(i)
end if
objconnection.Execute(strSQL)
Next
objConnection.close
set objConnection =nothing
Response.Write "&xieru=1&"
%>
3 回复
#2
szwda2013-02-24 09:24
这里的高手帮帮忙呀!
#3
szwda2013-02-26 08:28
程序代码:
<!--#include file="hezi.asp"-->
<%
dim sjid,bjid,wgid,cdid,qingsjia,qingbjia,wugu,chidao,sql
sjid=Split(request("sjid"),",",-1,1)
bjid=Split(request("bjid"),",",-1,1)
wgid=Split(request("wgid"),",",-1,1)
cdid=Split(request("cdid"),",",-1,1)
qingsjia=request("qingsjia")
qingbjia=request("qingbjia")
wugu=request("wugu")
chidao=request("chidao")

for i=0 to chidao-1
dim strSQL1
strSQL1="UPDATE yinyuehe SET cdshu=cdshu+1 where id="&cdid(i)
objconnection.Execute(strSQL1)
Next
for i=0 to qingsjia-1
dim strSQL2
strSQL2="UPDATE yinyuehe SET sjshu=sjshu+1 where id="&sjid(i)
objconnection.Execute(strSQL2)
Next
for i=0 to qingbjia-1
dim strSQL3
strSQL3="UPDATE yinyuehe SET bjshu=bjshu+1 where id="&sjid(i)
objconnection.Execute(strSQL3)
Next
for i=0 to wugu-1
dim strSQL4
strSQL4="UPDATE yinyuehe SET wgshu=wgshu+1 where id="&sjid(i)
objconnection.Execute(strSQL4)
Next
objConnection.close
set objConnection =nothing
Response.Write "&xieru=1&"
%>
代码可以运行,但第二个for以下的值全记在一个id上了,盼高手指教。无限感激!
#4
szwda2013-02-26 08:51
太粗心了,后面全是一个sjid 了
1