File:product-catalog.html
Method:query.scalar(columns,*where,*order)
未指定的错误
数据库执行错误
xmls/product.xmls
...="{~product-detail.html?cid=*CatalogId&pid=*ProductId}">查看详情</span></div>
</a>
</li>#];
@querygoods=$query(product,product);
@querycata=$query(catalog,product);
@cid=$http.get(cid,0);
@ccid=$http.get(ccid,2);
@dian=$string(0.).append(@ccid);
@key=$http.get(key,$null);
@querygoods[CatalogId]=@cid;
@querycata[CatalogId]=@cid;
@AreaId=$shell[AreaId];
@querygoods[AreaId]=@AreaId;
@querycata[AreaId]=@AreaId;
$if(@cid==0){
@cataname=全部产品;
@querygoods[CatalogId]=@dian;
}
$else{
@cataname=@querycata.scalar(CatalogName,['CatalogId={*CatalogId} and AreaId={*AreaId}']);
}
@attrval=$http.get(attrval);
@sqwher=$empty;
@sqwher=['Status>0 and AreaId={*AreaId} {?} and CatalogPath like {#like(%CatalogId%)}'];
$if(@attrval.length()>0){
@querygoods[AttrValueIds]=@attrval;
@sqwher=['Status>0 and AreaId={*AreaId} {?} and CatalogPath like {#like(%CatalogId%)} and {#on(and,AttrValueIds,like,AttrValueIds,%\,,\,%)}'];
}
$if(@key<>$null){
@querygoods[ProductName]=@key;
@sqwher=...