标题:求教高手,我的代码错在哪?谢谢!
只看楼主
szwda
Rank: 1
来 自:深圳
等 级:新手上路
帖 子:13
专家分:0
注 册:2013-2-22
结帖率:50%
 问题点数:0 回复次数:3 
求教高手,我的代码错在哪?谢谢!
程序代码:
<!--#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&"
%>
2013-02-22 10:42
szwda
Rank: 1
来 自:深圳
等 级:新手上路
帖 子:13
专家分:0
注 册:2013-2-22
得分:0 
这里的高手帮帮忙呀!
2013-02-24 09:24
szwda
Rank: 1
来 自:深圳
等 级:新手上路
帖 子:13
专家分:0
注 册:2013-2-22
得分:0 
程序代码:
<!--#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上了,盼高手指教。无限感激!
2013-02-26 08:28
szwda
Rank: 1
来 自:深圳
等 级:新手上路
帖 子:13
专家分:0
注 册:2013-2-22
得分:0 
太粗心了,后面全是一个sjid 了
2013-02-26 08:51



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-398946-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 1.211642 second(s), 7 queries.
Copyright©2004-2025, BCCN.NET, All Rights Reserved