读书人

asp排序方式解决不了解决方案

发布时间: 2012-03-17 19:06:28 作者: rapoo

asp排序方式解决不了
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
dim rst
Set Rst=Conn.Execute("Select * From Class Where Layout='Faq' and ParentID="& Rs("ClassID") &" order by RootID,OrderID")
i=1
Do While Not Rst.Eof
%>
<tr>

<td class="left_c2">  <img src="Images/icon_02.gif" width="9" height="9" /> 
<a href="faq-line.asp?classid=<%=rst("ClassID")%>" target="_parent"><%=Rst("ClassName")%></a>
</td>
</tr>
<tr>
<td height="1" background="Images/dot_01.gif"><img src="Images/space.gif" width="1" height="1" /></td>
</tr>
<%
Rst.MoveNext
Loop
Rst.Close
Set Rst=Nothing
%>
</table>

[解决办法]
<table>
<%
dim rst
Set Rst=Conn.Execute("Select * From Class Where Layout='Faq' and ParentID="& Rs("ClassID") &" order by RootID,OrderID")
i=1
Do While Not Rst.Eof
%><tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">

<tr>
<td class="left_c2">   <img src="Images/icon_02.gif" width="9" height="9" />  <a href="faq-line.asp?classid= <%=rst("ClassID")%>" target="_parent"> <%=Rst("ClassName")%> </a> </td>
</tr>
<tr>
<td background="Images/dot_01.gif"><img src="Images/space.gif" width="1" height="1" /> </td>
</tr>

</table></td>
</tr> <%
Rst.MoveNext
Loop
Rst.Close
Set Rst=Nothing
%>
</table>

读书人网 >网页设计

热点推荐