File:cn/goods.htm
Method:query.scalar(columns,*where,*order)
'and' 附近有语法错误。
select top 1 GoodsName FROM cpgoods WHERE GuId = '55585-28-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)}']);
@EnGoodsName=@querygoods.scalar(['EnGoodsName'],['{*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=@querygo...