File:cn/content.htm
Method:query.map(columns,*where,*order)
关键字 'and' 附近有语法错误。
select top 1 * FROM cocontent WHERE CatalogId=6 and AreaId= and ContentId<1777 ORDER BY ContentId desc
数据库执行错误
cn/xmls/news.xmls
...'ContentId desc']);
@nextrow=@query.map(*,['CatalogId={*CatalogId} and AreaId={*AreaId} and ContentId>{*ContentId}'],['ContentId asc']);
//上一条
$if(@prevrow<>$empty&&@nextrow<>$null){
@prevhref=$join(../content,["/{@nextrow[ContentId]}.html"]);
@prevtitle=["{@nextrow[Title]}"];
}
$else{
@prevhref=["javascript:void(0)"];
@prevtitle=["无"];
}
//下一条
$if(@nextrow<>$empty&&@prevrow<>$null){
@nexthref=$join(../content,["/{@prevrow[ContentId]}.html"]);
@nexttitle=["{@prevrow[Title]}"];
}
$else{
@nexthref=["javascript:void(0)"];
@nexttitle=["无"];
}
@rownext=$map();
@rownext[prevhref]=@prevhref;
@rownext[prevtitle]=@prevtitle;
@rownext[nexthref]=@nexthref;
@rownext[nexttitle]=@nexttitle;
$shell.put(@rownext);
$return($empty);
}
//新闻列表
$sub NewslistPro(format,pager,counts){
@querynew=$query(content,content);
@listnews=@querynew.pager(*,['Status>0 and {*AreaId = $shell.getData(cn)} and {*CatalogId = 8}'],['Grade desc,Modified desc,ContentId desc'],@counts,$get(page...