File:cn/productview.html
Function Code:510
Method Code:10
关键字 'and' 附近有语法错误。
select top 8 GoodsID,GoodsCode,Pic,GoodsName,ENGoodsName,CAS FROM shopgoods WHERE catalogid= and goodsid>225407 ORDER BY 1 asc
数据库执行错误
class/product.xmlc
...pzw.png'; this.onerror=null;" alt="{*GoodsName}" /></a>
<span>{*GoodsCode}<br />
<h2><a href="{#^:?xmls=cn/productview.html&goodsid={*GoodsID\}&goodscode={*GoodsCode\}}" style="font-size:12px;font-weight:normal;">CAS：{*CAS}</a></h2>
{*ENGoodsName}</span>
</div></li>
%};
@query=$query(goods,goods);
@querygoods=$query(goods,goods);

@catalogid=@querygoods.dataScalar(catalogid,{% GoodsCode='{@GoodsCode}' and catalogid>0%},GoodsID desc);
//$write(@catalogid);
//$end();
//推荐产品，改为按照分类搜索
@data=@query.format(@format,{% top 8 GoodsID,GoodsCode,Pic,GoodsName,ENGoodsName,CAS%},{% catalogid={@catalogid} and goodsid>{@goodsid} %},{% 1 asc %});
@data=$join(<div class="r_a_b" style="margin-top:15px;"><span style="font-size:16px;">Related Products</span><ul>,@data,</ul></div>);
$return(@data);
}

//4500cas推广页
$sub caslist(){
@format={%##:{=body}<div class="search_product_table">
{@data[list]}
</div>
<div class="fanye1">
<table border="0" cellpadding="0" cellspacing="0"><tr><td ...