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

编辑Tag赚U币
教程Tag:暂无Tag,欢迎添加,赚取U币!

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

来源:模板无忧//所属分类:动易Cms教程/更新时间:2009-07-28
相关动易Cms教程