File:cn/new.htm
Method:query.dataMap(sql)
关键字 'and' 附近有语法错误。
select top 1 * from cocatalog where and Status>0
数据库执行错误
cn/xmls/new.xmls
...us]=0;
@queryFeedr[AreaId]=1;
@cg=@queryFeedr.insert(1);
$write($map.serialize(Status,ok).toJson());
}
//右侧导航
$sub newRight(){
@format=[#
<a href="{*CelevantURL}">{*CatalogName}</a>
#];
@queryCat=$query(catalog,content);
@CatTable=@queryCat.dataTable(['select* from {#0} where Status>0 and parentid=9 order by Grade desc']);
@CatList=@CatTable.format(@format);
$return(@CatList);
}
//标题
$sub newTitle(){
@querynew=$query(catalog,content);
@querynew[CatalogId]=$argv(0,$null);
@map=@querynew.dataMap(['select top 1 * from {#0} where {*CatalogId =} and Status>0']);
@map[Title]=@map[CatalogName];
$shell.put(@map);
$return($empty);
}