File:en/productShow.html
Method:query.table(columns,*where,*order,*top)
关键字 'and' 附近有语法错误。
select * FROM jxpitem WHERE GoodsCode= and USDPrice !=0.00 ORDER BY Grade desc,ItemId asc
数据库执行错误
en/xmls/product.xmls
...
}
@view=@querygoods.map(*,['Status=1 and GoodsID={*GoodsID}']);
$if(@view==$null){
@view=$map();
$write(['<script>alert("Abnormal data"); window.location = "product.html";</script>']);
}
}
$else{
@view=$map();
$write(['<script>alert("Abnormal data"); window.location = "product.html";</script>']);
}
//产品详情页面-End
//-------------------------------------------查询产品规格-Start----------------------------------
@queryItem=$query(item,goods);
@queryItem[GoodsCode]=@view[GoodsCode];
@tableItem=@queryItem.table(*,['GoodsCode={*GoodsCode} and USDPrice !=0.00'],['Grade desc,ItemId asc']);
@format=['<li style="background: #e5f0f9;">
<span style="width: 200px;">{*ItemName}</span>
<span style="width: 175px;">{*USDStock}</span>
<span style="width: 175px;">{@Stock}</span>
<span style="width: 200px;">{@USDPrice}</span>
<span style="width: 175px;">{@status}</span>
<span style="width: 175px;">
<input type="checkbox" name="ItemName" type="checkbo...