File:en/KITST.htm
Method:query.scalar(columns,*where,*order)
'WHERE' 附近有语法错误。
select top 1 CatalogName FROM cpcatalog WHERE
数据库执行错误
themes/theme/en/xmls/engoods.xmls
...<span class="prev">
<a href="{*prev}">
<img src="{#root}themes/theme/en/images/xj1.png" alt="">
</a>
</span>
{*list}
<span class="next">
<a href="{*next}">
<img src="{#root}themes/theme/en/images/xj2.png" alt="">
</a>
</span>
#],50000,@count,$get(page,1),page,3);
$return($empty);
}
$sub Goodsview(){
@query=$query(catalog,goods);
@querys=$query(catalog,goods);
@query[CatalogId]=$argv(0);
@ParentId=@query.scalar(ParentId,['{*CatalogId =}']);
@querys[CatalogId]=@ParentId;
@CatalogName=@querys.scalar(CatalogName,['{*CatalogId =}']);
@map=@query.map(*,['{*CatalogId =}']);
$return($empty);
}
$sub catalist(format){
@query=$query(catalog,goods);
@query[CatalogId]=$argv(0);
@ParentId=@query.scalar(ParentId,['{*CatalogId =}']);
@query[ParentId]=@ParentId;
@table=@query.dataTable(['select * from cpcatalog where Status>0 and ParentId={@ParentId} order by CatalogName collate Chinese_PRC_CI_AS']);
//@table=@query.table(*,['Status>0 and {*ParentId =}'],['Gra...