File:cn/goods2.htm
Method:query.table(columns,*where,*order,*top)
引发类型为“System.OutOfMemoryException”的异常。
select * FROM cpitem ORDER BY ItemId desc
数据库执行错误
cn/xmls/goodsss.xmls
...m=@queryItem.table(*,['{*GoodsCode =} and {*BrandCode =}'],['ItemId desc']);
@queryItem[GoodsCode]=$argv(0,$null);
@queryItem[Guid]=$argv(0,$null);
@tableItem=@queryItem.table(*,['{*GoodsCode =}'],['ItemId desc']);
@body=@tableItem.format(@format){
$if(@UserId){
@Goodsmprice();
}
$else{
@price=$var[Price];
}
@Price=$number.round(@price,2);
}
$return(@body);
}
//规格
$sub formatGoodsItem2(format){
@UserId=$session[UserId];
@queryItem=$query(item,goods);
@cid=$argv(1);
//如果类别id为0 属于推荐产品 不带入类别标识 查询全部规格
$if(@cid==0){
@queryItem[CAS]=$argv(0,$null);
@querygoods=$query(goods,goods);
@querygoods[GoodsId]=$argv(1);
@GoodsCode=@querygoods.scalar(GoodsCode,['{*GoodsId =}']);
@queryItem[GoodsCode]=@GoodsCode;
@queryItem[BrandCode]=$argv(2);
@tableItem=@queryItem.table(*,['{*GoodsCode =}'],['ItemId desc']);
}
$else{
@queryItem[CAS]=$argv(0,$null);
@querygoods=$query(goods,goods);
//@querygoods[GoodsId]=$argv(0);
@querygoods[GuId]=$argv(0,$null...