急!急!急！ADODB.Recordset (0x800A0E78)对象关闭时，不允许操作

Answer 1

分类: 电脑/网络 >> 程序设计 >> 其他编程语言
问题描述:

[url=zhidao.baidu/question/showinfo?id=<%=rs1(]我做个一个网页，但是总是显示对象关闭，无法连接。

请各位大侠帮帮忙

程序如下：

<%set rs=server.CreateObject("adodb.recordset")

sql = "select * from class"

rs.open sql, conn, 1,1

if rs.bof and rs.eof then

rs.close

else

do while not rs.eof

%>

<table width=400 cellpadding="0" cellspacing="0" border=0>

<tr><td width=400 height=30 background="image/biaoti"> <span class="样式0"><%=rs("ClassName")%></span></td></tr>

<tr><% Set rs1=Server.CreateObject("ADODB.RecordSet")

if info<>"" then

sql1="select * from news where ClassName='"&info&"' order by id desc"

rs1.Open sql1,conn,1,1

end if

if rs1.eof and rs1.bof then *******提示出错行******

response.Write("暂时没有记录")

else

for i = 1 to 6 %>
<td height=20 bgcolor="#FFFFFF"><div align=left><span > <span >※ </span></span><a href="showinfo?id=<%=rs1("id")%>" target="_blank" >

<SCRIPT>

String.prototype.Tlength = function(){var arr=this.match(/[^\x00-\xff]/ig);return this.length+(arr==null?0:arr.length);}

String.prototype.left = function(num,mode){if(!/\d+/.test(num))return(this);var str = this.substr(0,num);if(!mode) return str;var n = str.Tlength() - str.length;num = num - parseInt(n/2);return this.substr(0,num);}

document.write("<%=rs1("title")%>".left(24,true));

</SCRIPT></a><span class="STYLE22">(<%= rs1("infotime") %>)</span></div></td>

<% rs1.movenext

if rs1.eof then exit for

next

rs1.close

end if

%> </tr>
<tr><td height=21 bgcolor="#FFFFFF"><div align=right><span ><a href="infolist?info=<%=rs("ClassName")%>" target="_blank">More>></a></span></div></td></tr></table>

<%rs.movenext

loop

rs.close

end if

%>

解析:

[/url]把“if rs1.eof and rs1.bof then *******提示出错行****** ”上一行的 end if 放到 rs1.close 行的下面。