File:cn/solvekt.htm
Method:query.table(columns,*where,*order,*top)
該帳戶當前被鎖定，所以用戶 'sa' 登錄失敗。系統管理員無法將該帳戶解鎖。
數據庫執行錯誤
cn/xmls/public.xmls
...
//產品導航
$function BanndProduct(id,pageY){
@format=[#
<ul class="showll">
<li>
<div class="li_tit">
<img src="{#root}cn/images/bo.jpg">
<a href="{~product/*CatalogId}">{*CatalogName}</a>
</div>
<ul class="neishow">
{@Prolist}
</ul>
</li>
</ul>
#];
@format1=[#
<li>
<a href="{~product/*ParentId_*CatalogId_@iid}">
<img src="{#root}cn/images/tb18.jpg">
<span class="pra">
{*CatalogName}
</span>
</a>
</li>
#];
@queryCat=$query(catalog,product);
@queryCat[ParentId]=@id;
@CatTableP=@queryCat.table(['CatalogId,Grade'],['{*ParentId =} and Status>0'],['Grade desc']);
@aa=@CatTableP.foreach(){
@queryCat[ParentId]=$var[CatalogId];
@iid=$var[CatalogId];
@CatTable=@queryCat.pager(*,['Status>0 and {*ParentId =}'],['Grade desc'],4,@pageY);
@Catlist=@CatTable.format(@format){
@queryCat[ParentId]=$var[CatalogId];
@ProTable=@queryCat.table(*,['{*ParentId =} and Status>0'],['Grade desc']);
@Prolist=@ProTable.format(@format1);
}
$return(@Catlist);
}
}
...