| 发表于:2007-01-06 15:20:251楼 得分:0 |
已经解决,不过循环次数过多。。 set rs=server.createobject( "adodb.recordset ") sql= "select * from userinf " rs.open sql,conn,1 if rs.eof then else i=0 do while not rs.eof if i mod 5 =0 then response.write " </tr> <tr> " end if %> <td align= "center " style= "line-height:150%;font-size:12px "> <input type= "checkbox " name= "userid " value= " <%=rs( "id ")%> " <% set rss=server.createobject( "adodb.recordset ") sqll= "select userid from groupuser where groupid= "&groupid rss.open sqll,conn,1 do while not rss.eof if rs( "id ")=rss( "userid ") then response.write "checked " end if rss.movenext loop rss.close set rss=nothing %> > <%=rs( "name ")%> </td> <% rs.movenext i=i+1 loop end if rs.close set rs=nothing | | |
|