File:cn/goods.htm
Method:query.table(columns,*where,*order,*top)
引发类型为“System.OutOfMemoryException”的异常。
select * FROM hecontent WHERE CatalogId = 4 and Status>0 and AreaId = 1 ORDER BY Grade desc,CatalogId asc
数据库执行错误
cn/xmls/frame.xmls
...[CatalogId]} and Status>0'],['Grade desc,CatalogId desc']);
@listtb=@tablect.format(@format1);
}
$cache.set(menupc,@listta,60000);
$return(@listta);
}
//帮助
$sub HelpList(format,format1){
@listta=$cache.get(help);
$if(@listta<>$null){
$return(@listta);
}
@querygcont=$query(content,help);
@querygcata=$query(catalog,help);
@tablectmn=@querygcata.table(*,['Status>0 and ParentId=0 and {*AreaId = $shell.getData(cn)}'],['Grade desc,CatalogId asc']);
@listta=@tablectmn.format(@format){
@tablect=@querygcont.table(*,['{*CatalogId = $var[CatalogId]} and Status>0 and {*AreaId = $shell.getData(cn)}'],['Grade desc,CatalogId asc']);
@listtb=@tablect.format(@format1);
}
$cache.set(help,@listta,60000);
$return(@listta);
}