File:en/productDtetails.html
Method:query.scalar(columns,*where,*order)
关键字 'and' 附近有语法错误。 select top 1 EnCatalogName FROM gocatalog WHERE CatalogId= and AreaId=1
数据库执行错误
en/xmls/product.xmls
... 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[Symbol]=@cid;
@AreaId=1;
@querygoods[AreaId]=1;
@querycata[AreaId]=1;
@catid=@querygoods.scalar(CatalogId,['Symbol={*Symbol} 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(){
@CatalogId=$var[value];
$if(@CatalogId<>$empty&&@CatalogId<>0){
@querycata[C...