File:en/producDtetails.html
Method:query.scalar(columns,*where,*order)
关键字 'and' 附近有语法错误。 select top 1 CatalogId FROM gogoods WHERE symbol= and AreaId=1
数据库执行错误
en/xmls/product.xmls
...nt=['<div style="color: #FF0000; font-size: 12px; height: 45px; line-height: 45px; text-align: center;">Sorry, there is no data at the moment!</div>
'];
}
@map=$map();
@map[list]=@content;
@map[pages]=$number.ceiling((@count/8));
@map[count]=@count;
$write(@map.toJson());
}



//查询内容
$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...