File:cn/xmls/goods.xmls
Method:query.map(columns,*where,*order)
'=' 附近有语法错误。
select top 1 GoodsName,RelevantIds,GoodsId FROM cpgoods WHERE CAS=
数据库执行错误
cn/xmls/goods.xmls
...ght:45px;text-align:center;">对不起，暂无相关产品!</div>'];
}
$write(@GoodsLists);
}
//推荐产品
$ajax GoodsTjs(){
@format=[#<li class="fl">
<a class="block" href="{~../goods/*Guid}">
<span class="block"><img class="maxwh" data-cas="{*CAS}" src="{@picc}" alt=""></span>
<div >
<p class="wot">{#left(GoodsName,20,...)}</p>
<p class="fomar wot">{*GoodsCode}</p>
</div>
</a>
</li>#];
@GuId=$post(Guid);
@querygoods=$query(goods,goods);
@querycatalog=$query(catalog,goods);
@querygoods[GuId]=@GuId;
@rowg=@querygoods.map(['GoodsName,RelevantIds,GoodsId'],['CAS={*GuId}']);
@RelevantIds=@querygoods.scalar(Recommend,['CAS={*GuId}']);
$if(@RelevantIds){
@querygoods.set(RelevantIds,@RelevantIds,number);
@Goodslist=@querygoods.table(['EnGoodsName,GoodsName,CAS,GoodsCode,Guid'],['Status>0 and {*CAS in @RelevantIds}'],['GoodsId desc'],5);
@GoodsLists=@Goodslist.format(@format){
@pic=$var[GoodsCode];
$if(@pic<>$null){
@src=["/files/images/goods/{@pic}.png"];
$if($file.existsFile($file.getMap...