问题:下载频道的软件管理中是按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 "
新闻热点
疑难解答
图片精选