File:product4.html
Method:query.table(columns,*where,*order,*top)
')' 附近有语法错误。 select CatalogName,CatalogId FROM gocatalog WHERE AreaId=1 and ()
数据库执行错误
xmls/product.xmls
...aId]=@AreaId;
@querycata[AreaId]=@AreaId;
@rowGoods=@queryGoods.map(*,['GoodsCode={*GoodsCode} and AreaId={*AreaId}']);
@picpath=["/files/cas/{@rowGoods[CAS]}.gif"];
$if($file.existsFile($file.getMapPath(@picpath))==1){
@pic=@picpath;
}
$else{
@pic=['/pinggao/images/zanwu.jpg'];
}

@cpath=@rowGoods[CatalogPath];
@querycata[CatalogPath]=@cpath;
@querycata[CatalogId]=@rowGoods[CatalogId];
@catalognames=@querycata.scalar(CatalogName,['CatalogId={*CatalogId} and AreaId={*AreaId}']);
@
catatb=@querycata.table(['CatalogName,CatalogId'],['AreaId={*AreaId} and ({#on(or,CatalogPath,like,CatalogPath,%,%)})']);
@Symbollist=@queryGoods.scalar(['Symbol'],['AreaId={*AreaId} and GoodsCode={*GoodsCode}']);
@Symbofor=$string(@Symbollist).split(\;);
@Symbol=$string();
@Symbofor.foreach(){
@Symbol.append(["<img src='{$var[value]}'/> &nbsp &nbsp"]);
}
@cnames=@catatb.format([#<a href="{~product2.html&cid=*CatalogId}" style="color:#666666;float:left"> {*CatalogName}</a> <span style="fl...