File:product.html
Method:query.table(columns,*where,*order,*top)
关键字 'and' 附近有语法错误。 select * FROM jxpcatalog WHERE ParentId= and AreaId=1 ORDER BY Grade asc,CatalogId asc
数据库执行错误
xmls/product.xmls
...'Grade asc,CatalogId asc']);
@listta=@tablectmn.format(@format){
@cataname=$string($var[SearchName]);
}
$return(@listta);
}







$function getCatalogLists(format){
@querygcata=$query(catalog,goods);
@query=$query(goods,goods);
@AreaId=1;
@querygcata[AreaId]=@AreaId;
@default=$http.get(default,0);
@querygcata[SearchName]=@default;
@catalogid=@querygcata.scalar(['CatalogId'],['SearchName={*SearchName} and AreaId={*AreaId}']);

@querygcata[ParentId]=@catalogid;
@count=0;
@
tablectmn=@querygcata.table(*,['ParentId={*ParentId} and AreaId={*AreaId}'],['Grade asc,CatalogId asc']);
@listta=@tablectmn.format(@format){
@cataname=$string($var[SearchName]);
@CatalogId=$var[CatalogId];
@CatalogPath=[".{@CatalogId}."];
@query[CatalogPath]=@CatalogPath;
@count=@query.scalar(['count(*)'],['CatalogPath like {#like(%CatalogPath%)} and Status>0']);
}
$return(@listta);
}


$function getCatalogListss(format){
@querygcata=$query(catalog,goods);
@AreaId=1;
@querygcata[...