File:news-info.htm
Method:query.map(columns,*where,*order)
语法错误 (操作符丢失) 在查询表达式 'ContentId < 46 and AreaId = 1 and' 中。
select top 1 * FROM cocontent WHERE ContentId < 46 and AreaId = 1 and ORDER BY ContentId desc
数据库执行错误
xmls/news.xmls
...s="nextBooks1">上一篇:<a href="JavaScript:;">无</a></p>"];
}
$if(@queryNext<>$null){
@conId=@queryNext[ContentId];
@title=@queryNext[Title];
@next=["<p class="nextBooks2">下一篇:<a href="{~aboutUs-welfare-info/@conId}">{@title}</a></p>"];
}
$else{
@next=["<p class="nextBooks2">下一篇:<a href="JavaScript:;">无</a></p>"];
}
$return($empty);
}
$sub newspn2(){
@query=$query(content,content);
@id=$argv(0);
@cid=@query.scalar(CatalogId,['{*ContentId = @id} and {*AreaId = $shell[AreaId]}']);
@queryPrev=@query.map(*,['{*ContentId < @id} and {*AreaId = $shell[AreaId]} and {*CatalogId = @cid}'],['ContentId desc']);
@queryNext=@query.map(*,['{*ContentId > @id} and {*AreaId = $shell[AreaId]} and {*CatalogId = @cid}'],['ContentId asc']);
$if(@queryPrev<>$null){
@conId=@queryPrev[ContentId];
@title=@queryPrev[Title];
@prev=["<p class="nextBooks1">
上一篇:<a href="{~news-info/@conId}">{@title}</a>
</p>"];
}
$else{
@prev=["<p class="nextBooks1">
上一篇:<a href="JavaScript:;">无</a>
<...