分行问题

[深圳还是一样的深圳]

如何分几行显示


<%
strSQL = "SELECT * FROM Products_id WHERE PJ = 1 AND Pid like '" & rs("Pid") & "%' ORDER BY [ID]"
SET rs1 = Conn.Execute(strSQL)
If Not (rs1.EOF AND rs1.BOF) Then

Do While Not rs1.EOF

%>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>


<td width="100%" height="29" align="left" valign="top"><table width="64" height="29" cellpadding="0" cellspacing="0" background="images/about_menu_1.gif">
<!--DWLayoutTable-->
<tr>
<td width="64" height="29" align="center" valign="middle"><a href="guoleiyou.asp?s=<%= rs1("Pid") %>" target="_self" class="menuyou_link_3"><%= rs1("PName") %></a></td>
</tr>
</table> </td>
<td width="1" height="29" align="left" valign="top"></td>


</tr>

</table>

<%
rs1.MoveNext
Loop


End If
rs1.Close():SET rs1 = Nothing
%>

[liuwei_IT_love]

<%
strSQL = "SELECT * FROM Products_id WHERE PJ = 1 AND Pid like '" & rs("Pid") & "%' ORDER BY [ID]"
SET rs1 = Conn.Execute(strSQL)
If Not (rs1.EOF AND rs1.BOF) Then
%>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<%
Do While Not rs1.EOF
%>
<tr>

<td width="100%" height="29" align="left" valign="top"> <table width="64" height="29" cellpadding="0" cellspacing="0" background="images/about_menu_1.gif">
<!--DWLayoutTable-->
<tr>
<td width="64" height="29" align="center" valign="middle"> <a href="guoleiyou.asp?s= <%= rs1("Pid") %>" target="_self" class="menuyou_link_3"> <%= rs1("PName") %> </a> </td>
</tr>
</table> </td>
<td width="1" height="29" align="left" valign="top"> </td>
</tr>
<%
rs1.MoveNext
Loop
%> </table>

<%
End If
rs1.Close
SET rs1 = Nothing
%>
关闭连接这样写就行，没必要那么复杂

[深圳还是一样的深圳]

我加了FOR 循环,

设定一行显示十条, 如果总数只有十八条时,就出错了,

也就说显示到十八条时,还在查找记录,提示记录被删除等信信息






<table width="64" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->






<tr>

<%
strSQL = "SELECT * FROM Products_id WHERE PJ = 1 AND Pid like '" & rs("Pid") & "%' ORDER BY [ID]"
SET rs1 = Conn.Execute(strSQL)
If Not (rs1.EOF AND rs1.BOF) Then

Do While Not rs1.EOF
aaa=1
for i = 1 to 10
%>

<td width="64" height="29" align="left" valign="top"><table width="64" height="29" cellpadding="0" cellspacing="0" background="images/about_menu_1.gif">
<!--DWLayoutTable-->
<tr>
<td width="64" height="29" align="center" valign="middle">


<a href="shengneiyou.asp?s=<%= rs1("Pid") %>" target="_self" class="menuyou_link_3" ><%= rs1("PName") %></a></td>
</tr>
</table> </td>
<td width="1" height="29" align="left" valign="top"></td>


<%

rs1.MoveNext


aaa=aaa+1

next

Response.Write "</tr>"

Loop


End If

rs1.Close():SET rs1 = Nothing
%>

</tr>





</table>

[never exists]

不行的话 循环tr