File:en/productdet.htm
Method:query.map(columns,*where,*order)
关键字 'and' 附近有语法错误。
select top 1 * FROM cpcatalog WHERE ParentId= and CatalogId>41 and AreaId = 1 ORDER BY Grade desc,CatalogId asc
数据库执行错误
en/xmls/brand.xmls
...rowGoods[Smiles]).length();
$if(@EnSmiles>60){
@Smiles=["{$string(@rowGoods[Smiles]).substring(0,50)}<br />{$string(@rowGoods[Smiles]).substring(50,55)}..."];
}
$else{
@Smiles=@rowGoods[Smiles];
}
$return($empty);
}
//上一篇,下一篇
$sub newsid(){
@querytwo=$query(catalog,goods);
@CatalogId=$argv(0);
@querytwo[CatalogId]=@CatalogId;
@ParentId=@querytwo.scalar(['ParentId'],['CatalogId={*CatalogId}']);
@AreaId=$shell[AreaId];
@querytwo[AreaId]=@AreaId;
@querytwo[ParentId]=@ParentId;
@newsid=@querytwo.map(*,['ParentId={*ParentId} and CatalogId>{*CatalogId} and AreaId = 1'],['Grade desc,CatalogId asc']);
$if(@newsid<>$null){
@id=@newsid[CatalogId];
@prev=["
<a href="{~productdet/@id}" class="page-next">下一篇<img src="../images/page-rg.png"></a>
"];
}
$else{
@prev=$empty;
@title=$empty;
}
@querytwo[CatalogId]=$argv(0);
@ParentId=@querytwo.scalar(['ParentId'],['CatalogId={*CatalogId}']);
@querytwo[ParentId]=@ParentId;
@AreaId=$shell[AreaId];
@querytwo[AreaId]=@Area...