File:news-details.html
Method:query.table(columns,*where,*order,*top)
关键字 'ORDER' 附近有语法错误。
ORDER BY Grade desc,ContentId desc
数据库执行错误
xmls/news.xmls
...row[CatalogId]}&id={@nextrow[ContentId]}"]);
@nexttitle=["{@nextrow[Title]}"];
}
$else{
@nexthref=["javascript:void(0)"];
@nexttitle=["无上一条"];
}
$return($empty);
}
//相关新闻
$function xianglist(format){
@pcontent=$query(content,content);
@id=$http.get(id);
@pcontent[ContentId]=@id;
@relaid=@pcontent.scalar(relationpro,['ContentId={*ContentId}']);
$if(@relaid==$empty){
@relaid=0,0;
}
@pcontent[relationpro]=@relaid;
@sql=['Status>0 and {#on(or,ContentId,like,relationpro)}'];
@table=@pcontent.table(*,['Status>0 and {#on(or,ContentId,like,relationpro)}'],['Grade desc,ContentId desc']);
@list=@table.format(@format);
$return(@list);
}