File:chemical.html
Method:query.table(columns,*where,*order,*top)
语法错误 (操作符丢失) 在查询表达式 'CatalogId= and AreaId=1' 中。 select * FROM cpproduct WHERE CatalogId= and AreaId=1 ORDER BY Grade desc,ProductId asc
数据库执行错误
xmls/product.xmls
$function main(){
$shell.call($http.get(method));
}

//产品模块分类
$function listProduct1(format){
@querygcata=$query(catalog,product);
@querygproduct=$query(product,product);
@querygcata[ParentId]=$http.get(pid);
@querygcata[CatalogName]=['模块分类'];
@CatalogId=@querygcata.scalar(CatalogId,['ParentId={*ParentId} and CatalogName={*CatalogName} and AreaId=1']);
@querygproduct[CatalogId]=@CatalogId;
@
tablectmn=@querygproduct.table(*,['CatalogId={*CatalogId} and AreaId=1'],['Grade desc,ProductId asc']);
@listta=@tablectmn.format(@format);
$return(@listta);
}

//产品功能分类
$function listProduct2(format){
@querygcata=$query(catalog,product);
@querygproduct=$query(product,product);
@querygcata[ParentId]=$http.get(pid);
@querygcata[CatalogName]=['功能分类'];
@CatalogId=@querygcata.scalar(CatalogId,['ParentId={*ParentId} and CatalogName={*CatalogName} and AreaId=1']);
@querygproduct[CatalogId]...