問題描述:
[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 行的下面。