File:gonewsg.html
Method:query.dataPager(columns,where,order,size,page,*countVar)
列名 'Grade1' 无效。
列名 'grade1' 无效。
列名 'Grade1' 无效。
select * from (select top 1 * from (select top 10 * from jxcontent where Status>0 and CatalogId=335 and AreaId=1 order by Grade1 desc,CreateDate desc,ContentId desc) as tab1 order by grade1,createdate,contentid) as tab2 order by Grade1 desc,CreateDate desc,ContentId desc
数据库执行错误
xmls/news.xmls
...a href="{~goviewg.html&cid=*CatalogId&id=*ContentId}" target="_blank"><span class="num"></span>{*Title}</a><span class="date">{@date}</span></li>
#];
@querycata=$query(catalog,content);
@querynew=$query(content,content);
@CatalogId=$http.get(cid,41);
@querynew[CatalogId]=@CatalogId;
@querycata[CatalogId]=@CatalogId;
@AreaId=$shell[AreaId];
@querycata[AreaId]=@AreaId;
@querynew[AreaId]=@AreaId;
@cataname=@querycata.scalar(CatalogName,['CatalogId={*CatalogId} and AreaId={*AreaId} ']);
@listnews=@querynew.dataPager(*,['Status>0 and CatalogId={*CatalogId} and AreaId={*AreaId}'],['Grade1 desc,CreateDate desc,ContentId desc'],10,$http.get(page,1));
@Pager=$control.execute(pager,[#
{?option}<a href="{*link}">{*text}</a>
{?selected}<a href="{*link}">{*text}</a>
{?pager}
<a href="{*home}">首页</a>
<a href="{*prev}">上一页</a>
{*list}
<a href="{*next}">下一页</a>
<a href="{*last}"...