File:product.xmls
Method:query.scalar(columns,*where,*order)
语法错误 (操作符丢失) 在查询表达式 'Status>0 and and 1<0' 中。
select top 1 count(*) FROM newscontent WHERE Status>0 and and 1<0
越界或超过范围
product.xmls
...}
$if(@t==1){
@ids=$array();
@query[ParentId]=$http.argv(2);
@query[CatalogId]=$http.argv(2);
@form2=@query.getRow(*,['CatalogId={*CatalogId}']);
@title1=@form2[CatalogName];
@cataid=$http.argv(2);
@cataname=@title1;
@cataList=@query.getTable(['CatalogId'],['Status>0 and ParentId={*ParentId}']);
@ids=@cataList.toArray(['CatalogId']);
@query=$query(content,news);
@query[CatalogId]=@ids;
@search=[''];
@description=[''];
@Body=[''];
@t=1;
@sql=['Status>0 and {#in(CatalogId)} '];
@count=@query.scalar(['count(*)'],@sql);
@index=$http.get(page,#n,1);
@product=@query.getList(['ContentId,Title,Pic,Subtitle,CreateDate,Grade'],['Status>0 and {#in(CatalogId)} '],['Grade desc,{#idn(0)} desc'],15,@count,@index);
@pager=$util.pager(15,@count,@index,page,3);
@contenList=@query.dataList(['select * from newscontent where UserId=1 order by Grade desc, Modified desc']);
}
$if(@t==2){
@search=$http.argv(2);
@ids=$array();
@ids=@catalist.toArray(['CatalogId']);
@query[ParentId...