File:products02.html
Method:query.table(columns,*where,*order,*top)
关键字 'ORDER' 附近有语法错误。
select * FROM goitem WHERE GoodsCode='H-3543' and ORDER BY Grade asc,ItemId desc
数据库执行错误
xmls/product.xmls
...
<td><span class="colorfc fontWe" id="{*ItemId}cmberprice">{*USDPrice}</span></td>
<td><label class="list-chage" for=""><input name="ItemName" type="checkbox" value="{*ItemId}"></label></td>
</tr>
#];
@queryItem=$query(item,goods);
@queryfile=$query(document,download);
@queryItem[GoodsCode]=@rowGoods[GoodsCode];
@queryfile[Goodshao]=@rowGoods[GoodsCode];
@FilePath=@queryfile.scalar(['FilePath'],['Goodshao={*Goodshao} and DocumentType=1']);
$if(@FilePath==$null){
@FilePath=$empty;
}
@tableItem=@queryItem.table(*,['GoodsCode={*GoodsCode} and'],['Grade asc,ItemId desc']);
@bodysz=@tableItem.format(@format){
@db=$db();
@UserId=$http.getSession(UserId);
$if(@UserId<>$null){
@Stock=$var[Stock];
$if(@Stock<0){
@shu=0;
}
$else{
@shu=1;
}
@USDStock=$var[USDStock];
@db[UserId]=@UserId;
@sqlzhe=['select Discount from ususerType where TypeId=(select UserType from ususer where UserId={*UserId})'];
@discount1=@db.dataScalar(@sqlzhe);
@price=$var[USDPrice];
@totals=(@...