28,390
社区成员
发帖
与我相关
我的任务
分享
set Rs = Server.CreateObject("adodb.recordset")
set Re = Server.CreateObject("adodb.recordset")
set Rd = Server.CreateObject("adodb.recordset")
Rs.open "select * from 表 where pid=0 and cid=0",conn,1,1'第一步,查询主题
i = 1
while not Rs.eof
Response.write i
Re.open "select * from 表 where pid="&rs("id"),conn,1,1'第二步,查跟贴
e= 1
while not Re.eof
response.write e
Rd.open "select * from 表 where cid="&Re("id"),conn,1,1'第三步,查跟贴的回贴
d = 1
while not Rd.eof
response.write d
Rd.movenext
d = d + 1
wend
Rd.close
Re.movenext
e = e + 1
wend
Re.close
Rs.movenext
i = i + 1
wend
Rs.close
set Rs = Server.CreateObject("adodb.recordset")
set Re = Server.CreateObject("adodb.recordset")
set Rd = Server.CreateObject("adodb.recordset")
Rs.open "select * from 表 where pid=0 and cid=0",conn,1,1'第一步,查询主题
while not Rs.eof
Re.open "select * from 表 where pid="&rs("id"),conn,1,1'第二步,查跟贴
while not Re.eof
Rd.open "select * from 表 where cid="&Re("id"),conn,1,1'第三步,查跟贴的回贴
while not Rd.eof
Rd.movenext
wend
Rd.close
Re.movenext
wend
Re.close
Rs.movenext
wend
Rs.close
当然,这样查速度很慢