再次求救！双层sql嵌套如何实现分页。分数可以再加。

[iis88mm]

如何对resourseid内容做分页呢？
sql="select knowledge,knowledgeid from g_knowledge where knowledge like '%"&keyword&"%'"
'求knowledgeid
set rs2=conn.execute(sql)

do while not rs3.eof
knowledge1=rs3("knowledge")

sql="SELECT resourseid FROM G_Knowledge_Resource WHERE (knowledgeid = "&rs3("knowledgeid")&") order by resourceid"

'根据knowledgeid搜索resourseid'
set rs2=conn.execute(sql)

do while not rs2.eof
....显示resourseid
rs2.movenext
loop

rs3.movenext
loop

[zorou_fatal]

为什么不用一个sql 语句来解决问题呢？
SELECT resourseid FROM G_Knowledge_Resource WHERE knowledgeid in (select knowledge,knowledgeid from g_knowledge where knowledge like '%"&keyword&"%')
order by resourceid