28,391
社区成员
发帖
与我相关
我的任务
分享
if Uc(j)&""<>"" and IsNumeric(Uc(j)&"") then
set rs2=server.CreateObject("adodb.recordset")
rs2.open "select * from Ty_users where Cid="&Cint(Uc(j))&" and Spd='1'",conn,1,1
if not rs2.eof then
Sjr=Sjr+rs2.recordcount
end if
while not rs2.eof
Allid=Allid&rs2("id")&","
rs2.movenext
wend
rs2.close
set rs2=nothing
end if
if Uc(j)&""<>"" then
set rs2=server.CreateObject("adodb.recordset")
rs2.open "select * from Ty_users where Cid="&Cint(Uc(j))&" and Spd='1'",conn,1,1
if not rs2.eof then
Sjr=Sjr+rs2.recordcount
end if
while not rs2.eof
Allid=Allid&rs2("id")&","
rs2.movenext
wend
rs2.close
set rs2=nothing
end if