File:cn/goodss.htm
Method:query.scalar(columns,*where,*order)
'WHERE' 附近有语法错误。
select top 1 CatalogName FROM cpcatalog WHERE
数据库执行错误
cn/xmls/goodsss.xmls
...Name,Detail1,Detail2,CatalogId'],['{*GuId =} and {*AreaId = $shell.getData(cn)}']);
@Name=$join(@rowGoods[CAS],|,@rowGoods[GoodsName],|,@rowGoods[EnGoodsName],|,@rowGoods[MDL]);
@querycata=$query(catalog,goods);
@cid=@rowGoods[CatalogId];
//如果类别id为0 属于推荐产品 设置默认标题
$if(@cid==0){
@CatalogName=首页推荐;
@CatalogName2=产品推荐;
}
$else{
@querycata[CatalogId]=@cid;
@CatalogName=@querycata.scalar(['CatalogName'],['{*CatalogId =}']);
@pid=@querycata.scalar(['ParentId'],['{*CatalogId =}']);
//1
@querycata[CatalogId]=@pid;
@CatalogName2=@querycata.scalar(['CatalogName'],['{*CatalogId =}']);
}
$shell[Title]=$join(@Name,-,$shell.getData(metaTitle));
$shell[keywords]=$join(@rowGoods[AnotherName],|,@rowGoods[EnAnotherName]);
$shell[description]=$join(@rowGoods[Detail1],|,@rowGoods[Detail2]);
$return($empty);
}
$sub startGoods(){
@querygoods=$query(goods,goods);
//@querygoods[GoodsId]=$argv(0);
@querygoods[GuId]=$argv(0,$null);
@rowGoods=@querygoods.map(['GoodsName,En...