File:cn/products.html
Method:query.scalar(columns,*where,*order)
'=' 附近有语法错误。
select top 1 count(*) FROM jxpcatalog WHERE ParentId=
数据库执行错误
cn/xmls/product.xmls
...lign:center;">对不起,当前没有数据！</div>'];
@Pager=$empty;
}
$return($empty);
}
//产品类别
$function getCatalogList(format){
@querygcata=$query(catalog,goods);
@ParentId=$http.get(PId);
@querygcata[ParentId]=@ParentId;
@tablectmn=@querygcata.table(*,['ParentId={*ParentId}'],['Grade asc,CatalogId desc']);
@listta=@tablectmn.format(@format){
}
$return(@listta);
}
//产品数量
$sub getCount(){
@querygcata=$query(catalog,goods);
@ParentId=$http.get(PId);
@querygcata[ParentId]=@ParentId;
@countmn=@querygcata.scalar(['count(*)'],['ParentId={*ParentId}']);
$return($empty);
}
//产品
$sub ProductList(){
@format=[#
<li>
{@pic}
<table width="100%" border="0" class="jstable">
<tr>
<td colspan="2">{#left(EnglishName,26,...)}</td>
</tr>
<tr>
<td><p>产品编号：</p></td>
<td>{*Goodshao}</td>
</tr>
<tr>
<td><p>CAS No：</p></td>
<td>{*CAS}</td>
</tr>
</table>
<div class="pidous">
{@ahref}
</div>
</li>
#];
@querygoods=$query(goods,goods);
@CatalogId=$http.get(CId,$null);
@...