File:research-deta.html
Method:query.map(columns,*where,*order)
关键字 'and' 附近有语法错误。 select top 1 ParentId,CatalogName FROM cocatalog WHERE Status>0 and CatalogId= and AreaId=1
数据库执行错误
xmls/news.xmls
..."<a href="research-deta.html?&id={@id}" class="deta-down-r">下一篇</a>"];
}
$else{
@next=["<a href="javascript:;" class="deta-down-r">无</a>"];
@title2=$empty;
}
$return($empty);
}
//详情导航
$sub Navigationss(){
@query=$query(content,content);
@query[ContentId]=$http.get(id,$null,N);
@AreaId=$shell[AreaId];
@query[AreaId]=@AreaId;
@result=@query.scalar(['CatalogId'],['Status>0 and ContentId={*ContentId} and AreaId=1']);
@querylog=$query(catalog,content);
@querylog[CatalogId]=@result;
@
firstName=@querylog.map(['ParentId,CatalogName'],['Status>0 and CatalogId={*CatalogId} and AreaId=1']);
@querylog[CatalogId]=@firstName[ParentId];
@nextName=@querylog.map(['CatalogName,ParentId,CatalogId'],['Status>0 and CatalogId={*CatalogId} and AreaId=1']);
@querylog[CatalogId]=@nextName[ParentId];
@lastName=@querylog.scalar(['CatalogName'],['Status>0 and CatalogId={*CatalogId} and AreaId=1']);
$return($empty);
}
//交易规则
$sub Tradingrules(){
@queryprofile=$query(content,content);
@Ca...