File:cn/forgot-password.htm
Method:query.table(columns,*where,*order,*top)
在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: Named Pipes Provider, error: 40 - 无法打开到 SQL Server 的连接)
数据库执行错误
cn/xmls/frame.xmls
...d {*AreaId = $shell.getData(cn)}']);
@listta=@tabletim.format(@format){
@querygcata[ParentId]=$var[CatalogId];
@count=@querygcata.scalar(['count(Id)'],['ParentId={*ParentId} and Status>0 and {*AreaId = $shell.getData(cn)}']);
$if(@count>0){
@pageUrl=$shell.view(productpage,$var[CatalogId]);
}
$else{
@pageUrl=$shell.view(product,$var[CatalogId]);
}
};
$return(@listta);
}
//关于我们栏目
$sub sortConetent(format,cId){
@querycata=$query(catalog,content);
@querycata[ParentId]=@cId;
@catatable=@querycata.table(['CatalogName,PageName,CatalogId'],['{*ParentId =} and Status>0 and {*AreaId = $shell.getData(cn)} ']);
@index=0;
@cataList=@catatable.format(@format){
@index=(@index+1);
};
$return(@cataList);
}
//多层分类，两层
$sub GoodsCatalog(format,format1){
@cacheCatalog=$cache[cacheCatalog];
$if(!@cacheCatalog){
@querygcata=$query(catalog,goods);
@tablectmn=@querygcata.table(*,['ParentId=0 and Status>0 and {*AreaId = $shell.getData(cn)}'],['Grade desc,CatalogId desc']);
@...