Error-数据库执行错误

File:cn/product.htm

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

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

数据库执行错误

themes/theme/cn/xmls/product.xmls

...一层分类
$sub cataloglist(format){
@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);
$return(@listta);
}

//多层分类，两层
$sub GoodsCatalog(format,format1){
@querygcata=$query(catalog,goods);
@id=$argv(0);
$if(@id){
@querygcata[CatalogId]=@id;
@CatalogName=@querygcata.scalar(CatalogName,['{*CatalogId =}']);
}
$else{
@CatalogName=["全部产品"];
}
@tablectmn=@querygcata.table(*,['ParentId=0 and Status>-1 and {*AreaId = $shell.getData(cn)}'],['Grade desc,CatalogId desc']);
@listta=@tablectmn.format(@format){
@isd=$var[CatalogId];
$if(@id==@isd){
@style=["display:block"];
}
$else{
@style=[""];
}

@tablect=@querygcata.table(*,['{*ParentId = $var[CatalogId]} and Status>0'],['Grade desc,CatalogId desc']);
@listtb=@tablect.format(@format1);
}
$return(@listta);
}

$ajax productdetail(){
@format=[#
<h3>你想询价的产品</h3>
<p>
<em><i c...