File:en/product-main.htm
Method:query.dataScalar(sql)
'where' 附近有语法错误。
select top 1 catalogName from cpcatalog where
数据库执行错误
en/xmls/goods.xmls
...n();
$write(@json);
}
//各类产品列表
$sub goodsclasslist(){
@format=[# <div class="product-item trs textC">
<div class="product-img">
<img src="{#root}files/images/goods/{*CAS}.png" data-cas="{*CAS}" alt="">
</div>
<p>{*GoodsName}</p>
<div class="product-href">
<a href="{~product-details/*CatalogId_*GoodsId}">详情</a>
</div>
</div>
#];
@querygoods=$query(goods,goods);
@querygoods[CatalogId]=$argv(0,$null);
@querygcata=$query(catalog,goods);
@querygcata[CatalogId]=$argv(0,$null);
@cataName=@querygcata.dataScalar(['select top 1 catalogName from cpcatalog where {*CatalogId = }']);
@goodslist=@querygoods.pager(['CatalogId,GoodsName,GoodsId,Pic,CAS'],['{*CatalogId = } and Status>0 and AreaId=1'],['GoodsId desc'],16,$get(page,1));
@PCcoent=@goodslist.format(@format){
}
@pager=$helper.pager([#
{?option}<a href="{*link}">{*text}</a>
{?selected}<span>{*text}</span>
{?pager}
<a href="{*prev}" class="prev">Prev</a>
{*list}
<a href="{*next}" class="next">Next</a>
#],16,...