File:category-2.html
Method:query.scalar(columns,*where,*order)
'=' 附近有语法错误。 select top 1 CatalogName FROM jxpcatalog WHERE CatalogId=
数据库执行错误
xmls/product.xmls
...ta.scalar(CatalogName,['CatalogId={*CatalogId}']);
}
$return(@cname);
}



//查询内容
$sub GoodsDetails(){
@querycata=$query(catalog,goods);
@querygoods=$query(goods,goods);
@queryitem=$query(item,goods);
@querybrand=$query(brand,goods);
@gcode=$http.get(default,0);
@querygoods[GoodsCode]=@gcode;
@GoodsId=@querygoods.scalar(GoodsId,['GoodsCode={*GoodsCode}']);
@cid=@querygoods.scalar(CatalogId,['GoodsCode={*GoodsCode}']);
@querycata[CatalogId]=@cid;
@queryitem[GoodsId]=@GoodsId;
@
cname=@querycata.scalar(CatalogName,['CatalogId={*CatalogId}']);
@pid=@querycata.scalar(ParentId,['CatalogId={*CatalogId}']);
$if(@pid<>$null){
@querycata[CatalogId]=@pid;
@pname=@querycata.scalar(CatalogName,['CatalogId={*CatalogId}']);
}
$else{
@pname=$empty;
}
@querygoods[GoodsId]=@GoodsId;
@rowgoods=@querygoods.map(*,['GoodsId={*GoodsId}']);
@ghs=@rowgoods[GHS];
$if(@ghs==$empty){
@ghsimg=[''];
}
$else{
@sktype=$string(@ghs).split(\,);
@ghsimg=$string();
@sktype.foreach(){ ...