Error-数据库执行错误

File:cn/goods.htm

Method:query.table(columns,*where,*order,*top)

关键字 'ORDER' 附近有语法错误。 select * FROM cpcatalog WHERE ParentId=0 and Status>0 and ORDER BY Grade desc,CatalogId desc

数据库执行错误

cn/xmls/frame.xmls

$sub main(){
$shell.call($get(method));
}

//多层分类，两层
$sub GoodsCatalog(format,format1){
@querygcata=$query(catalog,goods);
@tablectmn=@querygcata.table(*,['ParentId=0 and Status>0 and {*AreaId = $shell.getData(cn)}'],['Grade desc,CatalogId desc']);
@listta=@tablectmn.format(@format){
@tablect=@querygcata.table(*,['{*ParentId = $var[CatalogId]} and Status>0'],['Grade desc,CatalogId desc']);
@listtb=@tablect.format(@format1);
}
$return(@listta);
}

//帮助
$sub HelpList(format,format1){
@querygcont=$query(content,help);
@querygcata=$query(catalog,help);
@tablectmn=@querygcata.table(*,['Status>0 and ParentId=...