File:pumpcity.html
Method:query.table(columns,*where,*order,*top)
已成功与服务器建立连接，但是在登录前的握手期间发生错误。 (provider: Shared Memory Provider, error: 0 - 管道的另一端上无任何进程。)
数据库执行错误
index.xmls
...query(content,content);
@querytent[CatalogId]=@CatalogId;
@querytent[AreaId]=$shell[AreaId];
@querytent[TagIds]=@TagIds;
@tablelist=@querytent.table(*,['CatalogId={*CatalogId} and TagIds like {#like(%TagIds%)} and AreaId={*AreaId}'],['Grade asc,CreateDate desc'],1);
@list=@tablelist.format(@format);
$return(@list);
}
//资讯
$sub getNewsgroup(){
@format=[#<td><a data-gid="{*CatalogId}" href="{~pumpcity.html&cid=*CatalogId}">{*CatalogName}</a></td>#];
@querylog=$query(catalog,content);
@table=@querylog.table(*,['ParentId=7 and Status=1'],['Grade asc,Modified desc']);
@Newslist=@table.format(@format);
$return($empty);
}
//优化搜索
$sub selectKeyword(){
@query=$query(catalog,content);
@query[CatalogId]=$http.get(cid);
@keywordlist=@query.map(*,['CatalogId={*CatalogId}']);
$return($empty);
}
//资讯列表
$sub getNewslist(){
@querytent=$query(content,content);
@format=[#
<a href="{~pumpcity-detail.html&id=*ContentId}">
<div class="aylist clearfix">
<div class="ayleft">
<h1>...