File:interior_company.htm
Method:query.scalar(columns,*where,*order)
'WHERE' 附近有语法错误。 select top 1 CatalogName FROM cpcatalog WHERE
数据库执行错误
xmls/product.xmls
...Id]=@pppid;
@pppname=@querycontent.scalar(EnCatalogName,['CatalogId={*PPParentId}']);
@daohang=["
{@pppname}>
{@ppname}>
{@pname}>{@catalogname}
"];
}
}
}
}
$write($empty);
}


$sub FLTitle(){
@CatalogId=$argv(0);
@querygoods=$query(goods,goods);
@querycata=$query(catalog,goods);
@gid=$argv(0);
@querygoods[GoodsId]=@gid;
@CatalogId=@querygoods.scalar(CatalogId,['{*GoodsId =}']);
@GoodsName=@querygoods.scalar(GoodsName,['{*GoodsId =}']);
@querycata[CatalogId]=@CatalogId;
@
GCatalogName=@querycata.scalar(CatalogName,['{*CatalogId =}']);

@title=$string;
@title=["{@GoodsName}-{@GCatalogName}-公司树平台"];
$return(@title);
}

//公司学堂详情标题
$sub schoolTitle(){
@CatalogId=$argv(0);
@querygoods=$query(goods,goods);
@querycata=$query(catalog,goods);
@gid=$argv(0);
@querygoods[GoodsId]=@gid;
@CatalogId=@querygoods.scalar(CatalogId,['{*GoodsId =}']);
@GoodsName=@querygoods.scalar(GoodsName,['{*GoodsId =}']);
@querycata[CatalogId]=@CatalogId;
@GCatalogName=@queryca...