其实你可以用一个SQL语句来得到记录集.
do while not rsMenu.eof
set rsMenuTwo = server.createobject("ADODB.recordset")
msSql = "select * from mb_so_status where sts='A' and Type_ID='"&rsMenu("Type_ID")&"'"
rsMenuTwo.open msSql,Conn,3,1
"输出A表内容"
do while not rsMenuTwo.eof
"输出B表内容"
rsMenuTwo.movenext
loop
rsMenuTwo.close
set rsMenuTwo=thiong
rsMenu.movenext
loop
rsMenu.close
set rsMenu=thiong
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024