解析下載頻道審核軟件的排序問題_動(dòng)易Cms教程

問題：下載頻道的軟件管理中是按SOFTID字段降序排序，而點(diǎn)審核時(shí)，我需要按SOFTID升序排序，應(yīng)該如何修改？
解決：打開\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 "

查看更多 動(dòng)易Cms教程  動(dòng)易Cms模板