File:demo/productShow.html
Method:query.table(columns,*where,*order,*top)
关键字 'ORDER' 附近有语法错误。
select * FROM jxpitem WHERE GoodsCode= ORDER BY Grade desc,ItemId asc
数据库执行错误
demo/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}'],['Grade desc,ItemId asc']);
@format=['<li style="background:#e5f0f9;">
<span style="width:170px;">{*ItemName}</span>
<span style="width:230px;">{*USDStock}</span>
<span style="width:130px;">US</span>
<span style="width:120px;">{*USDPrice}</span>
<span style="width:155px;"><input name="qutity" maxlength="4" id="qu{*ItemId}" value="1" onblur="CheckServisNumber(this);" onbeforepaste="clipboardData.setData('text',clipboardData.getData('t...