请教高手,asp可以在循环中打开访问数据库吗?
<TR><td >制造厂家</td>
<td >
<%
' 制造厂家记录集
dim rsFactory
dim rs1Fasctory
strSql = "select * from sel_Factory "
set rsFactory = conn.execute(strSql)
while not rsFactory.eof
if len(rsFactory("strFactory"))>0 then '过滤掉为空的制造厂家
set rs1Fasctory=conn.execute("select * from sel_Factory_Desc where Factory='"&rsFactory("strFactory")&"'") '如果只有一层循环,这个语句一定没有错的
response.write "<TD>"
response.write rs1Fasctory("Name")
response.write "</TD></TR>"
rs1Fasctory.close
end if
rsFactory.movenext
wend
rsFactory.close
set rsFactory = nothing
%>
</SELECT>
</td>
ie6.0的错误提示是:ADODB.recordset错误.
help me!!!!