File:cn/about.htm
Method:query.scalar(columns,*where,*order)
'and' 附近有语法错误。 select top 1 Body FROM cocontent WHERE Status>0 and AreaId = 1 and
数据库执行错误
cn/xmls/news.xmls
...Name]=$argv(0,$null);
@CatalogId=@querycat.scalar(['CatalogId'],['{*PageName =} and {*AreaId = $shell.getData(cn)}']);
@querynew[CatalogId]=@CatalogId;
@listnews=@querynew.pager(*,['Status>0 and {*AreaId = $shell.getData(cn)} and {*CatalogId =}'],['Grade desc,Modified desc,ContentId desc'],@countc,$argv(1,1));
@row[contentlist]=@listnews.format(@listFormat){
$if($var[Link]){
@URL=$var[Link];
}
$else{
@URL=["{~content/$var[ContentId]}"];
}
}
@row[pager]=$helper.pager(@pageFormat,@coun
tc,@count,$argv(1,1),#1,3);
$if(@count==0){
@row[contentlist]=['<div style="color:#FF0000;font-size:12px;height:45px;line-height:45px;text-align:center;">Sorry,no data!</div>'];
@row[pager]=$empty;
}
$shell.put(@row);
$return($empty);
}

//新闻详情
$sub viewNews(){
@querycontent=$query(content,content);
@querycata=$query(catalog,content);
@ContentId=$argv(0,0);
@querycontent[ContentId]=@ContentId;
@CatalogId=@querycontent.scalar(CatalogId,ContentId={*ContentId});
@querycata[CatalogId...