为什么我每次执行都是死循环,,,,,真的郁闷!!!!代码如下: ------------------------------------------------------------------------------------------------------------------------------------ <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title></title> <link href="css/Admin_STYLE.CSS" rel="stylesheet" type="text/css"> </head>
<body> <!--#include file="conn_admin.asp"--> <% Set rs = Server.CreateObject("ADODB.Connection") sql = "select * from Xin_Product_BigType" Set rs = conn.Execute(sql) %> <table width="60%" border="0" align="center" cellpadding="0" cellspacing="2" class="border" > <tr> <td align="center">产品类别管理 增加产品大类 </td> </tr> <%do while not rs.EOF %> <tr > <td> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="2" class="border" > <tr class="title"> <td width="48%"> <img src="images/bigType.gif"> <font color="#FF0000"><%= rs("BigTypeId") %></font> <%= rs("BigTypeName") %> </td> <td width="18%" align="center">增加小分类</td> <td width="17%" align="center">修改</td> <td width="17%" align="center">删除</td> </tr> <tr> <td colspan="4"> <table cellpadding="0" cellspacing="2" border="0" class="border" width="100%"> <% Set rs1 = Server.CreateObject("ADODB.Connection") sql1 = "select * from Xin_Product_SmallType" Set rs1 = conn.Execute(sql1) do while not rs1.EOF %> <tr> <td width="5%"> </td> <td width="45%"><%= rs1("SmallTypeName") %></td> <td width="30%">修改分类信息</td> <td width="20%">删除分类</td> </tr> <% rs1.movenext loop rs1.close set rs1=nothing %> </table> </td> </tr> </table> </td> </tr> <% rs.movenext loop rs.close set rs=nothing %> </table> </body> </html> ------------------------------------------------------------------------------------------------------------- 只要我把红颜色的那些代码加进去以后就会死循环,系统提示,,脚本时间超时!!! 这个程序本来是一个产品的类别管理。。分2级的!!! PS:Xin_Product_BigType 表为大类表 Xin_Product_SmallType 表为小类表
[此贴子已经被作者于2005-6-22 9:12:58编辑过]