File:pumpcity.html
Method:query.map(columns,*where,*order)
'=' 附近有语法错误。 select top 1 * FROM jxcatalog WHERE CatalogId=
数据库执行错误
index.xmls
...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>{*Title}</h1>
<span>{#toDatetime(Modified,yyyy-MM-dd)}</span>
<p>{*Description}</p>
</div>
<div class="ayright">
<img src="{*Pic}">
</div>
</div>
</a>
#];
@CatalogId=$http.get(cid,8,N);
@querytent[CatalogId]=@CatalogId;
@queryt...