File:company/Product.htm
Method:query.scalar(columns,*where,*order)
关键字 'and' 附近有语法错误。 select top 1 CompanyName FROM uscompany WHERE and Status>0
数据库执行错误
company/frame.xmls
...ry1=$query(goods,goods);
@query1[GoodsId]=@list;
@GoodsName=@query1.scalar(GoodsName,['GoodsId= {*GoodsId}']);
}
$else{
@GoodsName=@title;
}
@query=$query(company,user);
@query[CompanyId]=@CompanyId;
@CompanyName=@query.scalar(CompanyName,['{*CompanyId =} and Status>0']);
$return($join(@CompanyName, | ,@GoodsName, | ,$shell.getData(metaTitle)));
}

$sub key(type){
@keywords=$empty;
$if(@type==0){
@CompanyId=$argv(0);
@query=$query(company,user);
@query[CompanyId]=@CompanyId;
@
keywords=@query.scalar(CompanyName,['{*CompanyId =} and Status>0']);
}
$else{
@GoodsId=$argv(1);
@query=$query(goods,goods);
@query[GoodsId]=@GoodsId;
@keywords=@query.scalar(GoodsName,['{*GoodsId =} and Status>0']);
}
$return(@keywords);
}

$sub desc1(type){
@CompanyStrengths=$empty;
$if(@type==0){
@CompanyId=$argv(0);
@query=$query(company,user);
@query[CompanyId]=@CompanyId;
@CompanyStrengths=@query.scalar(CompanyStrengths,['{*CompanyId =} and Status>0']);
}
$else{
@GoodsI...