File:cn/goods.htm
Method:query.table(columns,*where,*order,*top)
关键字 'and' 附近有语法错误。 select top 10 * FROM cocontent WHERE Status>0 and and TagIds like '%,3,%' ORDER BY Grade desc,Modified desc,ContentId desc
数据库执行错误
cn/xmls/goods.xmls
...($file.existsFile($file.getMapPath(@src))==1){
@picc=["{@src}"];
}
$else{
@picc=["/files/images/fande.png"];
}
}
}
$if(!@GoodsLists){
@count=0;
@GoodsLists=['<div style="color:#636262;font-size:12px;height:45px;line-height:45px;text-align:center;">对不起,暂无相关产品!</div>'];
}
$write(@GoodsLists);
}


//新闻
$sub glistNews(format,tagIds){
@row=$map();
@call=$call(xmls/public.xmls);
@call.load();
@querynew=$query(content,content);
@tagId=[",{@tagIds},"];
@querynew[TagIds]=@tagId;
@
listnews=@querynew.table( *,['Status>0 and {*AreaId = $shell[AreaId]} and {*TagIds like }'],['Grade desc,Modified desc,ContentId desc'],10);
@contentlist=@listnews.format(@format);
$if(@contentlist==$empty){
@contentlist=['<div style="color:#FF0000;font-size:12px;height:45px;line-height:45px;text-align:center;">抱歉,暂无数据!</div>'];
}
$return(@contentlist);
}