File:register_company.htm
Method:query.scalar(columns,*where,*order)
'=' 附近有语法错误。
select top 1 CatalogName FROM cpcatalog WHERE CatalogId=
数据库执行错误
xmls/product.xmls
...oodsId]=$get(goodsId);
@Price=@queryGoods.scalar(Price,['GoodsId={*GoodsId}']);
$if(@Price==$null){
@Price=咨询;
}
$write(@Price);
}
//导航
$function pageJianshe(){
@querycontent=$query(catalog,goods);
@id=$argv(0,0);
@querycontent[CatalogId]=@id;
$if(@id==0){
@daohang=[""];
}
$else{
//查自己本身
@catalogname=@querycontent.scalar(CatalogName,['CatalogId={*CatalogId}']);
//查父级
@parentid=@querycontent.scalar(ParentId,['CatalogId={*CatalogId}']);
@querycontent[ParentId]=@parentid;
@pname=@querycontent.scalar(CatalogName,['CatalogId={*ParentId}']);
@ppid=@querycontent.scalar(ParentId,['CatalogId={*ParentId}']);
$if(@parentid==0){
@daohang=["{@catalogname}"];
}
$else{
//查父级的父级
$if(@ppid==0){
@daohang=["{@catalogname}"];
}
$else{
@querycontent[PParentId]=@ppid;
@ppname=@querycontent.scalar(CatalogName,['CatalogId={*PParentId}']);
@pppid=@querycontent.scalar(ParentId,['CatalogId={*PParentId}']);
$if(@pppid==0){
@daohang=["{@pname}-{@catalogname}
"];
}
$else{
...