File:all product.html
Method:query.scalar(columns,*where,*order)
资源池 'default' 没有足够的系统内存来运行此查询。 select top 1 count(*) FROM jxpgoods WHERE Status>0 and CatalogId=87 and AreaId=1
数据库执行错误
xmls/product.xmls
...r=['Status>0 {?} and (GoodsName like {#like(%GoodsName%)} or EnglishName like {#like(%EnglishName%)} or CAS like {#like(%CAS%)} or GoodsCode like {#like(%GoodsCode%)} or MDL={*MDL} or MF like {#like(%MF%)} or Smile like {#like(%smile%)}) {?} and AreaId={*AreaId}'];
}
}
$else{
@querygoods[keywords]=$string(@keywords).trim();
@querygoods[type]=@type;
@sqwher=['Status>0 {?} and ({#object(type)} like {#like(%keywords%)}) {?} and AreaId={*AreaId}'];
}
}
@sqheres=@querygoods.sql(@sqwher);
@
count=@querygoods.scalar(['count(*)'],@sqwher);
@goodslist=@querygoods.dataPager(*,@sqwher,['Modified desc,Grade desc, GoodsId desc'],9,$http.get(page,1));
@Pager=$control.execute(pager,[#
{?option}<a href="{*link}">{*text}</a>
{?selected}<a href="{*link}" class="oncalass">{*text}</a>
{?pager}
<a href="{*prev}">上一页</a>
<a href="{*home}">首页</a>
{*list}
<a href="{*last}">尾页</a>
<a href="{*next}">下一页</a>
#],9,@count,$http.get(page,1),page,2);

@content=@goodslist.format(@format){
//@c...