File:index.html
Method:query.table(columns,*where,*order,*top)
用户 'sq_ziqi2024' 登录失败。
select top 15 * FROM jxcontent WHERE Status>0 ORDER BY Grade desc
数据库执行错误
xmls/index.xmls
$function main(){
}
//推荐品牌
$function getbrandList(format,TagIds,top){
@queryconet=$query(content,content);
@queryconet[CatalogId]=5;
@TagIds=[",{@TagIds},"];
@queryconet[TagIds]=@TagIds;
@tablect=@queryconet.table(*,['Status>0'],['Grade desc'],@top);
@zjlist=@tablect.format(@format);
$return(@zjlist);
}
//推荐新闻
$function getNewsList(format,TagIds,top){
@queryconet=$query(content,content);
@queryconet[CatalogId]=1,2;
@TagIds=[",{@TagIds},"];
@queryconet[TagIds]=@TagIds;
@tablect=@queryconet.table(*,['Status>0 and CatalogId in {#in(CatalogId)} and TagIds like {#like(%TagIds%)}'],['Modified desc,ContentId asc'],@top);
@newslist=@tablect.format(@format);
$return(@new...