ASP's code for sorting records

Sort

One, show the record

Set Rs=server.createobject ("Adodb.recordset")
Sql= "SELECT * from JFNEWSO where newsclass= ' theoretical dynamics ' and Classname= '" &session ("Fenlei") & "' ORDER by Displayorder des C,id DESC "
Rs.Open sql,conn,1,1

Second, modify the sort

<%
If Request ("action") = "OrderUp" Then
' Sort up
Set Rs=server.createobject ("Adodb.recordset")
Sql= "SELECT * from JFNEWSO where id= '" &request ("id") & ""
Rs.Open sql,conn,3,2
RS ("Displayorder") =rs ("Displayorder") +1
Rs.update
Rs.close
Set rs=nothing
Response.Write "<script Language=javascript>alert (' Edit success! '); Location.href (' Action=liebiao&fenlei= "&request (" Fenlei ") &" &xiangmu= "&request (" Xiangmu " ) & "');</script>"
End If
%>