File:product-details.html
Method:query.table(columns,*where,*order,*top)
在应使用条件的上下文(在 'GoodsCode' 附近)中指定了非布尔类型的表达式。
select * FROM goitem WHERE s GoodsCode='A-3824' 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(*,['s GoodsCode={*GoodsCode}'],['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=(@di...