File:en/product.html
Method:query.table(columns,*where,*order,*top)
标准表达式中数据类型不匹配。
select * FROM cpproduct WHERE CatalogId='2' and AreaId=2 ORDER BY CatalogId asc
数据库执行错误
en/xmls/product.xmls
...rv.table(*,['AttrNameId={*AttrNameId}'],['AttrValueId asc']);
@listtv=@tableattrv.format(@format1);
}
}
$return(@listta);
}
//产品二级分类
$function listproo(format,format1){
@querycata=$query(catalog,product);
@querycata1=$query(product,product);
@AreaId=$shell[AreaId];
@querycata[AreaId]=@AreaId;
@tablegs=@querycata.table(*,['ParentId=0 and AreaId={*AreaId} '],['CatalogId asc']);
@gslist=@tablegs.format(@format){
@querycata1[ParentId]=$var[CatalogId];
@querycata1[AreaId]=@AreaId;
@tabletwo=@querycata1.table(*,['CatalogId={*ParentId} and AreaId={*AreaId}'],['CatalogId asc']);
$if(@tabletwo<>$null){
@listwo=@tabletwo.format(@format1);
}
$else{
@listwo=$empty;
}
};
$return(@gslist);
}
//产品列表
$sub pageProudct(){
@format=[#<li>
<div class="baja">
<div class="bvga"><a href="{~productview.html&cid=*CatalogId&pid=*ProductId}"><img src="{*Pic}" width="230" height="230" /></a></div>
<div class="bvgb"...