File:en/KITS-add.htm
Method:query.map(columns,*where,*order)
'and1' 附近有语法错误。
select top 1 * FROM cpcatalog WHERE Status=1 and1 CatalogId=103 and AreaId=2
数据库执行错误
en/xmls/engoods.xmls
...roducts-add/*CatalogId}" class="clearfix">-->
<a href="{~KITST/*CatalogId}" class="clearfix">
<img src="../../themes/theme/en/images/pjian.png" alt="" class="fl">
<p class="fl">{*CatalogName}({@counts})</p>
</a>
</li>
#];
@query=$query(catalog,goods);
@table=@query.table(*,['Status=1 and ParentId={$argv(0,793)} and AreaId=2']);
@list=@table.format(@format){
@counts=@query.dataScalar(['select count(*) from cpgoods where CatalogPath like '%{$var[CatalogPath]}%' and AreaId=2']);
}
@goods=@query.map(*,['Status=1 and1 CatalogId={$argv(0,793)} and AreaId=2']);
$return($empty);
}
//��Ʒ��ѯ
$sub GetGoodsSearch(){
@format=[#
<li class="clearfix">
<div class="ser_names fl c1">
{*GoodsCode}<br/>
{*CAS}
</div>
<div class="ser_speck fl">
<div class="ser_speck_tit clearfix">
<p class="weld"><a href="{~ProductsThr/*GoodsCode}" style="cursor: pointer;"><span class="c1">{*EnGoodsName}</span></a></p>
</div>
<p class="ser_p">
{*Description}
</p>
</div>
</li>
#];
@f...