File:cn/goods.htm
Method:query.scalar(columns,*where,*order)
'WHERE' 附近有语法错误。
select top 1 GoodsCode FROM cpgoods WHERE
数据库执行错误
cn/xmls/goods.xmls
...r(sPrice,['{*GoodsCode =}']);
$if(@sprice==0){
@name=折扣价;
}
$else{
@name=促销价;
}
@queryGoods[GoodsId]=@rowGoods[GoodsId];
@queryGoods[Click]=(@rowGoods[Click]+1);
//@queryGoods.setField($field(Click,Click+1,objectformatGoodsItem));
@queryGoods.update();
@rowGoods[Gimg]=@gimg;
$shell.put(@rowGoods);
$return($empty);
}
//规格
$sub formatGoodsItem(format){
@UserId=$session[UserId];
@queryItem=$query(item,goods);
@queryGoods=$query(goods,goods);
@queryGoods[CAS]=$argv(0,$null);
@goodsCode=@queryGoods.scalar(GoodsCode,['{*CAS =}']);
@queryItem[GoodsCode]=@goodsCode;
@tableItem=@queryItem.table(*,['{*GoodsCode =}'],['Quality asc']);
@body=@tableItem.format(@format){
@pce=$var[Price];
$if(@pce==0){
@pcees=["<a target="_blank" href="http://wpa.qq.com/msgrd?v=3&uin=1910248762&site=qq&menu=yes">询价</a>"];
}
$else{
@pcees=$number.round(@pce,2);
}
@stock=$var[Description];
$if(@stock==0){
@stocks=["<a target="_blank" href="http://wpa.qq.com/msgrd?v=3&uin=1910248762&...