File:relationship.htm
Method:query.table(columns,*where,*order,*top)
语法错误 (操作符丢失) 在查询表达式 'Status>0 and AreaId=1 and ParentId=' 中。
select * FROM cocatalog WHERE Status>0 and AreaId=1 and ParentId=
数据库执行错误
xmls/Customize.xmls
...=@tables.format(@format){
}
$return(@list);
}
$sub preface(format){
@query=$query(catalog,content);
@tables=@query.table(*,['Status>0 and parentid=59'],['Grade desc']);
@list=@tables.format(@format){
@dates=$var[CreateDate];
@date=$datetime(@dates);
@year=@date.year();
@month=@date.month();
@day=@date.day();
}
$return(@list);
}
//Catalog查分类
$sub ContentClassifyIds(format,ids){
@query=$query(catalog,content);
@querycontent=$query(content,content);
@query[ParentId]=@ids;
@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}'],['Grade desc']);
@count=@table.count();
}
$return(@list);
}
//Catalog 动态父级查分类URL
$sub ContentClassifyUrl(format){
@query=$query(catalog,content);
@querycontent=$query(content,content);
@query[ParentId]=$argv(0);
@tables=@query.table(*,['Status>0 and AreaId=...