File:religious-culture.htm
Method:query.table(columns,*where,*order,*top)
'=' 附近有语法错误。
select * FROM cocatalog WHERE Status>0 and AreaId=1 and ParentId=
数据库执行错误
xmls/news.xmls
...content);
@query[ParentId]=10;
@tables=@query.table(*,['Status>0 and AreaId=1 and ParentId={*ParentId}'],['Grade desc']);
@list=@tables.format(@format){
@querycontent[CatalogId]=$var[CatalogId];
@table=@querycontent.table(*,['Status>0 and AreaId=1 and CatalogId={*CatalogId}']);
@count=@table.count();
}
$return(@list);
}
//Catalog URL传值版（动态父级查分类）
$sub Catalogurlclassifyt(format){
@query=$query(catalog,content);
@querycontent=$query(content,content);
@query[ParentId]=$argv(0);
@tables=@query.table(*,['Status>0 and AreaId=1 and ParentId={*ParentId}']);
@list=@tables.format(@format){
@querycontent[CatalogId]=$var[CatalogId];
@table=@querycontent.table(*,['Status>0 and AreaId=1 and CatalogId={*CatalogId}']);
@count=@table.count();
}
$return(@list);
}
//产品下拉列
$sub ProductexeCatalog(format,ids){
@query=$query(catalog,product);
@querycontent=$query(content,content);
@query[ParentId]=@ids;
@tables=@query.table(*,['Status>0 and AreaId=1 and ParentId={*ParentId}'...