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

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">&nbsp;&nbsp;<img src="Images/icon_02.gif" width="9" height="9" />&nbsp;
<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">&nbsp;&nbsp; <img src="Images/icon_02.gif" width="9" height="9" />&nbsp; <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>