File:en/productDtetails.html
Method:query.scalar(columns,*where,*order)
关键字 'and' 附近有语法错误。 select top 1 CatalogId FROM gogoods WHERE GoodsId= and AreaId=1
数据库执行错误
en/xmls/product.xmls
...">{*text}</a>
{?pager}
<a href="{*prev}" class="page-head">prev</a>
{*list}
<a href="{*next}" class="page-head">next</a>
<span class="page-sum2 page-txt2">{*page}/{*total}Pages</span></li>
#],8,@count,$http.get(page,1),page,1);


$write($empty);
}



//查询内容
$sub viewProduct(){
@querygoods=$query(goods,goods);
@querycata=$query(catalog,goods);
@cid=$http.get(symbol);
@querygoods[GoodsId]=@cid;
@AreaId=1;
@querygoods[AreaId]=1;
@querycata[AreaId]=1;
@
catid=@querygoods.scalar(CatalogId,['GoodsId={*GoodsId} and AreaId={*AreaId}']);
@catname=@querycata.scalar(EnCatalogName,['CatalogId={@catid} and AreaId={*AreaId}']);
@catpath=@querycata.scalar(CatalogPath,['CatalogId={@catid} and AreaId={*AreaId}']);
@querygoods[CatalogId]=@catid;
@querycata[CatalogId]=@catid;
@prentid=@querycata.scalar(ParentId,['CatalogId={*CatalogId} and AreaId={*AreaId}']);
@Name=$string();
@forpath=$string(@catpath).split(["."]);
@forpath.foreach()...