读书人

asp死循环有关问题

发布时间: 2012-03-01 10:25:46 作者: rapoo

asp死循环问题,急求助
我觉得走了死循环,请看是不是,帮帮忙,谢谢

<!--#include file= "conn.asp "-->
<%
ClassId = Clng(request( "ClassID "))
set rs = server.createobject( "adodb.recordset ")
sql = "select * from KH_Select where Parent_ID = " & ClassId & " order by Select_ID "
rs.open sql,conn,1,3
%>
<table border= "0 " align= "center " cellpadding= "0 " cellspacing= "0 " background= "images/box_w2.gif ">
<tr>
<td> <img src= "images/title_42.gif " width= "556 " height= "26 " /> </td>
</tr>
<%while not rs.eof
set rs_querry = server.createobject( "adodb.recordset ")
sql_querry = "select top 6 * from KH_Info where Type_large = ' " & rs( "Select_ID ") & " ' order by KH_creattime "

%>
<tr>
<td> <table width= "538 " height= "24 " border= "0 " align= "center " cellpadding= "0 " cellspacing= "0 " background= "images/title_bg1.gif ">
<tr>
<td width= "24 ">   </td>
<td width= "473 " class= "p4 "> <%=rs( "Select_Value ")%> </td>
<td width= "41 ">
<a href= "info_knowledge.asp?ClassID= <%=rs( "Select_ID ")%> " class= "link05 "> 更多 </a>
</td>
</tr>


</table> </td>
</tr>
<tr>

<td align=center> <TABLE width= '90% ' border= '0 '>
<%
set rs_querry = server.createobject( "adodb.recordset ")
rs_querry.open.sql_querry,1,1
do while not rs_querry.eof
%>
<tr>
<td> <ul class= "list032 ">
<li> <img src= 'images/li032.gif ' width= "9 " height= "15 ">   <a href= 'changshi_Show.asp?ArticleID= <%=rs_querry( "id ")%> ' title= '文章标题: <%=rs_querry( "KH_title ")%>
作 者: <%=rs_querry( "KH_author ")%>
更新时间: <%=rs_querry( "KH_creattime ")%>
点击次数: <%=rs_querry( "KH_hit ")%> ' target= '_blank ' class= "link04 "> <%=rs_querry( "KH_title ")%> </a> </li> </ul> </td>
</tr>
<%
rs_querry.movenext
loop
rs_querry.close
set rs_querry = nothing
%>
</table> </td>
</tr>
<%
rs.movenext
wend
%>
<tr>
<td>
</tr>
<tr>
<td> <img src= "images/box_x3.gif " width= "556 " height= "11 " /> </td>
</tr>


</table>

[解决办法]
结构上并没有死循环。查具体值。
[解决办法]
程序没发生循环,你检查下数据库

读书人网 >ASP

热点推荐