<%set rs=server.createobject("adodb.recordset")
sql="Select top 30 * from Staff  where name='"&name&"' and sid='"&sid&"' and cate="&cate
rs.open sql,conn,1,1
if not rs.eof then
do while not rs.eof
%>这段代码我想让内容升序排怎么写啊？

sql="Select top 30 * from Staff  where name='"&name&"' and sid='"&sid&"' and cate='"&cate&"' ORDER BY Id DESC "

DESC是降序，ASC是升序，默认为升序。