File:interior_company.htm
Method:query.scalar(columns,*where,*order)
'WHERE' 附近有语法错误。
select top 1 CatalogName FROM cpcatalog WHERE
数据库执行错误
xmls/product.xmls
...12,@count,$get(page,1),page,3);
$if(@count==0){
@content=['<div style="color: #FF0000; font-size: 12px; height: 45px; line-height: 45px; text-align: center;">对不起,当前没有数据！</div>'];
@pager=$empty;
}
$return($empty);
}
//产品详情
$sub viewGoods(){
@querygoods=$query(goods,goods);
@querycata=$query(catalog,goods);
@gid=$argv(0);
@querygoods[GoodsId]=@gid;
@AreaId=1;
@querygoods[AreaId]=@AreaId;
@CatalogId=@querygoods.scalar(CatalogId,['{*GoodsId =}']);
@querycata[CatalogId]=@CatalogId;
@GCatalogName=@querycata.scalar(CatalogName,['{*CatalogId =}']);
@sheng=@querygoods.scalar(city,['GoodsId={*GoodsId}']);
@qu=@querygoods.scalar(Qu,['GoodsId={*GoodsId}']);
$if(@sheng==$empty){
@hide=["display:none"];
}
$else{
@hide="";
}
@rowGoods=@querygoods.map(*,['GoodsId={*GoodsId} and AreaId={*AreaId}']);
$return($empty);
}
//推荐产品
$sub tuijianchanp(){
@format=[#
<li>
<a href="{~interior_company/*GoodsId}">
<div class="regi_boots_tu">
<img src="{*Pic}" alt="">
</div>
<di...