File:download-product.htm
Method:query.scalar(columns,*where,*order)
关键字 'ORDER' 附近有语法错误。
ORDER BY DocumentId desc
数据库执行错误
xmls/product.xmls
...ain(){
$shell.call($get(method));
}
$sub link(){
@query=$query(goods,goods);
@query[GoodsId]=$argv(0);
@mapsss=@query.scalar(link,['{*GoodsId =}']);
$return($empty);
}
$sub cataloglist(format,id){
@query=$query(catalog,goods);
@query[ParentId]=@id;
@table=@query.table(*,['Status>0 and ParentId={*ParentId}'],['Grade desc,CatalogId desc']);
@content=@table.format(@format);
$return(@content);
}
$sub zuixin(){
@query=$query(document,download);
@query[GoodsCode]=$get(id);
@time=@query.scalar(time,['Edition=0 and {*GoodsCode =} and Status>0'],['DocumentId desc']);
@time1=@query.scalar(time,['Edition=1 and {*GoodsCode =} and Status>0'],['DocumentId desc']);
@time2=@query.scalar(time,['Edition=2 and {*GoodsCode =} and Status>0'],['DocumentId desc']);
@version=@query.scalar(version,['Edition=0 and {*GoodsCode =} and Status>0'],['DocumentId desc']);
@version1=@query.scalar(version,['Edition=1 and {*GoodsCode =} and Status>0'],['DocumentId desc']);
@version2=@query...