File:web/Agent-brand1.html
Function Code:510
Method Code:15
语法错误 (操作符丢失) 在查询表达式 'Status>0 and Path like '%.870.%' and CatalogID=' 中。
select top 1 * FROM xxcontent WHERE Status>0 and Path like '%.870.%' and CatalogID= ORDER BY Grade desc
数据库执行错误
class/agent-brand.xmlc
....index();
//@index=(@index+1);
//@i=(@index%3);
//$if(@i==0){
//@style=margin-right:0px;
//}
//}
//$return(@format.toString(body));
//}

$sub agentzx(){
@query=$query(content,news);
@catalogid=$get.number(catalogid,37);
@catalogidd=$get.sql(catalogidd,$empty);
@where=;
$if(@catalogidd<>$empty){
@where={%#&:and CatalogID={@catalogidd}%};
}
$else{
@catalog=$query(catalog,news);
@cid=@catalog.dataScalar(CatalogID,ParentID={@catalogid});
@where={%#&:and CatalogID={@cid}%};
}
@data=@query.dataMap(*,Status>0 and Path like '%.{@catalogid}.%' {@where},{%Grade desc%});
$return($empty);
}

$sub guanyu(){
@query=$query(content,news);
@catalogid=$get.number(catalogid,507);
@catalogidd=$get.sql(catalogidd,$empty);
@where=;
$if(@catalogidd<>$empty){
@where={%#&:and CatalogID={@catalogidd}%};
}
$else{
@catalog=$query(catalog,news);
@cid=@catalog.dataScalar(CatalogID,ParentID={@catalogid});
@where={%#&:and CatalogID=508%};
}
@data=@query.dataMap(*,Status>0 and P...