File:en/productdet.htm
Method:query.map(columns,*where,*order)
關鍵字 'and' 附近有語法錯誤。 select top 1 * FROM cpcatalog WHERE ParentId= and CatalogId>11 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{
@[email protected][Smiles];
}

$return($empty);
}
//上一篇,下一篇
$sub newsid(){
@querytwo=$query(catalog,goods);
@CatalogId=$argv(0);
@querytwo[CatalogId][email protected];
@[email protected](['ParentId'],['CatalogId={*CatalogId}']);
@AreaId=$shell[AreaId];
@querytwo[AreaId][email protected];
@querytwo[ParentId][email protected];
@
[email protected](*,['ParentId={*ParentId} and CatalogId>{*CatalogId} and AreaId = 1'],['Grade desc,CatalogId asc']);
$if(@newsid<>$null){
@[email protected][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);
@[email protected](['ParentId'],['CatalogId={*CatalogId}']);
@querytwo[ParentId][email protected];
@AreaId=$shell[AreaId];
@querytwo[AreaId][email protected]
好运彩3计划