呵呵，无聊，为朋友的服写了修卡团和团人数不对应的几行代码，发出来，很简单。

1. 
   
2. set rs=conn.execute("select idnum,members,idname from knights")
   
3. do while not rs.eof
   
4.         set cs=conn.execute("select count(*) as b from userdata where knights="&rs("idnum"))
   
5.         if cs("b")<>rs("members") then
   
6.                 conn.execute("update knights set members="&cs("b")&" where idnum="&rs("idnum"))
   
7.                 response.write("OK<br />")
   
8.                 response.write rs("idname")&"--->"&rs("idnum")&"-->"&cs("b") &"-->"& rs("members")&"<br />"
   
9.         end if
   
10.         cs.close:set cs=nothing
    
11. rs.movenext
    
12. loop
    
13. rs.close:set rs=nothing
    

复制代码

再彻底一点，完全重新统计团员列表名单：

conn.execute("truncate table KNIGHTS_USER")
set rs=conn.execute("select struserid,knights from userdata order by knights")
do while not rs.eof
        if rs("knights")>0 then
                conn.execute("insert into KNIGHTS_USER(sIDNum,struserid) Values("&rs("knights")&",'"&trim(rs("struserid"))&"')")
                response.write("insert into KNIGHTS_USER(sIDNum,struserid) Values("&rs("knights")&",'"&trim(rs("struserid"))&"')")
                response.write("<br />")
        end if
rs.movenext
loop
rs.close:set rs=nothing

学习了~

学习不过记不住~~~

水1次！