File:cn/goods2.htm
Method:query.map(columns,*where,*order)
关键字 'and' 附近有语法错误。
select top 1 GoodsName,EnGoodsName,CAS,MDL,AnotherName,EnAnotherName,Detail1,Detail2,CatalogId FROM cpgoods WHERE and AreaId = 1
数据库执行错误
cn/xmls/goodsss.xmls
$sub main(){
$shell.call($get(method));
}
//标题
$sub start(){
@querygoods=$query(goods,goods);
//@querygoods[GoodsId]=$argv(0);
@querygoods[GuId]=$argv(0,$null);
@rowGoods=@querygoods.map(['GoodsName1,EnGoodsName,CAS,MDL,AnotherName,EnAnotherName,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...