解析下载频道审核软件的排序问题_动易Cms教程

问题：下载频道的软件管理中是按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 "

查看更多 动易Cms教程  动易Cms模板