conn未关闭情况下能否再次open
主要是想询问一下交叉sql查询的可能性
也就是说
在第一重查询中利用第一重的值进行第二重查询.
sql="select id,catalog_name from catalog where point_id=0"
Set rs=Conn.Execute(Sql)
i=0
if not rs.eof then
do while not rs.eof
i=i+1
a(i)=rs("catalog_name")
b(i)=rs("id")
response.write ("<tr><div id=Layer"& i &" onMousein=MM_showHideLayers('Layer"& i &"','','show') onMouseout=MM_showHideLayers('Layer"& i &"','','hide') style='position:absolute; width:97px; height:115px; z-index:"& i &"; left: 120px; top: 20px; visibility: hidden;'>")
sql1="select catalog_name from catalog where point_id='"&b(i)&"' order by id desc"
set rs1=server.createobject("ADODB.Recordset")
rs1.open sql1,conn,1,1
rs1.movefirst
do while not rs.eof
response.write rs("catalog_name")
response.write ("br")
loop
rs1=nothing
rs1.close
response.write ("</div><td><a href=# onMousein=MM_showHideLayers('Layer"& i &"','','show') onMouseout=MM_showHideLayers('Layer"& i &"','','hide')>"& a(i) &"</a></td></tr>")
rs.movenext
loop
else
response.write("there is no record")
end if
如何做到我想要的功能呢..