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>