File:cn/goods.htm
Method:query.scalar(columns,*where,*order)
'WHERE' 附近有语法错误。
select top 1 CatalogName FROM cpcatalog WHERE
数据库执行错误
cn/xmls/goods.xmls
...GuId =} and {*AreaId = $shell.getData(cn)}']);
@CAS=@querygoods.scalar(['CAS'],['{*GuId =} and {*AreaId = $shell.getData(cn)}']);
@AnotherName=@querygoods.scalar(['AnotherName'],['{*GuId =} and {*AreaId = $shell.getData(cn)}']);
@EnAnotherName=@querygoods.scalar(['EnAnotherName'],['{*GuId =} and {*AreaId = $shell.getData(cn)}']);
@Detail1=@querygoods.scalar(['Detail1'],['{*GuId =} and {*AreaId = $shell.getData(cn)}']);
@Detail2=@querygoods.scalar(['Detail2'],['{*GuId =} and {*AreaId = $shell.getData(cn)}']);
@MDL=@querygoods.scalar(['MDL'],['{*GuId =} and {*AreaId = $shell.getData(cn)}']);
$if(@GoodsName){
@Name=$join(@GoodsName,|,@EnGoodsName,|,@CAS,|,@MDL);
}
$else{
@Name=产品详情;
}
$shell[Title]=$join(@Name,-,$shell.getData(metaTitle));
$shell[keywords]=$join(@AnotherName,|,@EnAnotherName);
$shell[description]=$join(@Detail1,|,@Detail2);
$return($empty);
}
//导航列表
$sub catalogList(classA,Subgrade){
@querygcata=$query(catalog,goods);
@CatalogId=$argv(0,$null);
@ma...