問題:下載頻道的軟件管理中是按SOFTID字段降序排序,而點審核時,我需要按SOFTID升序排序,應該如何修改?
解決:打開/Admin/Admin_Soft.asp
第511行: Querysql = Querysql & " and S.SoftID < (select min(SoftID) from (select top " & ((CurrentPage - 1) * MaxPerPage) & " S.SoftID from PE_Soft S " & Querysql & " order by S.SoftID desc) as QuerySoft)"
改成這樣: Querysql = Querysql & " and S.SoftID > (select max(SoftID) from (select
top " & ((CurrentPage - 1) * MaxPerPage) & " S.SoftID from PE_Soft S " & Querysql & " order by S.SoftID ) as
QuerySoft) "
然后第517行: sql = sql & Querysql & " order by S.SoftID desc"
改成這樣: sql = sql & Querysql & " order by S.SoftID "
新聞熱點
疑難解答
圖片精選