File:cn/product2.htm
Method:query.table(columns,*where,*order,*top)
在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: Named Pipes Provider, error: 40 - 无法打开到 SQL Server 的连接)
数据库执行错误
cn/xmls/index.xmls
...
$return(@Pagelist);
}


$sub filedownload(format,ids){
@query=$query(content,content);
@query[CatalogPath]=@ids;
@query[CatalogId]=@ids;
@tables=@query.table(*,['Status>0 and CatalogId={*CatalogId} and AreaId=1'],['Grade desc'],8);
@list=@tables.format(@format){
@dates=$var[CreateDate];
@date=$datetime(@dates);
@year=@date.year();
@month=@date.month();
@day=@date.day();
}
$return(@list);
}


$sub ProList(format,ids){
@query=$query(catalog,goods);
@query[ParentId]=@ids;
@
tables=@query.table(*,['Status>0 and ParentId={*ParentId} and AreaId=1'],['Grade desc'],8);
@list=@tables.format(@format){
@dates=$var[CreateDate];
@date=$datetime(@dates);
@year=@date.year();
@month=@date.month();
@day=@date.day();
}
$return(@list);
}



$sub NewsList(format,ids){
@query=$query(content,content);
@query[CatalogPath]=@ids;
@query[CatalogId]=@ids;
@tables=@query.pager(*,['Status>0 and CatalogId={*CatalogId} and AreaId=1'],['Grade desc'],4,$get(page,1));
@list=@ta...