注册 登录
编程论坛 ASP技术论坛

代码可以运行,但第二个for以下的值全记在一个id上了,盼高手指教。无限感激!

szwda 发布于 2013-02-26 08:31, 326 次点击
程序代码:
<!--#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上了,盼高手指教。无限感激!
3 回复
#2
szwda2013-02-26 08:50
太粗心了,后面全是一个sjid 了
#3
elongtown2013-03-01 08:36
呵呵,自己解决
#4
wp2319572013-03-01 10:26
善意的接分来了
1