File:product-detail.html
Method:query.table(columns,*where,*order,*top)
超出系统资源。
select * FROM cpattrvalue WHERE AttrValueId in (00) ORDER BY AttrValueId asc
数据库执行错误
xmls/product.xmls
...eaId]=@AreaId;
@cataname=@querycata.scalar(CatalogName,['CatalogId={*CatalogId} and AreaId={*AreaId}']);
@prentid=@querycata.scalar(ParentId,['CatalogId={*CatalogId} and AreaId={*AreaId}']);
@rowdata=@querygoods.row(@GoodsId);
@Modified=$empty;
$if(@rowdata==$null){
@rowdata=$map();
@rowdata[ProductName]=无数据;
}
$else{
//产品属性
@format=[#
<p>{*AttributeName}:{*AttributeValue}</p>
#];
@AttrValueIds=@rowdata[AttrValueIds];
@queryattr[AttrValueId]=$string.join(0,@AttrValueIds,0);
@tableattr=@queryattr.table(*,['AttrValueId in ({*AttrValueId})'],['AttrValueId asc']);
@listattr=@tableattr.format(@format);
}
$return($empty);
}
//查询内容
$sub viewProduct11(){
@querygoods=$query(product,product);
@querycata=$query(catalog,product);
@queryattr=$query(attrvalue,product);
@querypro=$query(pro,product);
@GoodsId=$http.get(pid,2);
$write(["<span style="display:none">{@GoodsId}</span>"]);
@cid=$http.get(cid);
@querycata[CatalogId]=@GoodsId;
@AreaId=$shell[AreaId];
...