File:cn/goods.htm
Method:query.scalar(columns,*where,*order)
'and' 附近有语法错误。
select top 1 GoodsName FROM cpgoods WHERE GuId = '1059626-05-9' and
数据库执行错误
cn/xmls/goods.xmls
$sub main(){
$shell.call($get(method));
}
//标题
$sub start(){
@querygoods=$query(goods,goods);
@querygoods[GuId]=$argv(0,$null);
@GoodsName=@querygoods.scalar(['GoodsName'],['{*GuId =} and {*AreaId = $shell.getData(cn)}']);
$if(@GoodsName){
@Name=@GoodsName;
}
$else{
@Name=产品详情;
}
$shell[Title]=$join(@Name,-,$shell.getData(metaTitle));
$return($empty);
}
//导航列表
$sub catalogList(classA,Subgrade){
@querygcata=$query(catalog,goods);
@CatalogId=$argv(0,$null);
@map=$map();
$if(@CatalogId){
@CatalogPath=[",{@CatalogId},"];
@querygcata[CatalogId]=@CatalogId;
@map[parentName]=@querygcata.scalar(CatalogName,['{...