首页 > CMS > 动易CMS > 正文

解析下载频道审核软件的排序问题

2024-09-10 21:56:16
字体:
来源:转载
供稿:网友

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

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表

图片精选