国产日韩午夜视频在线观看,狼友在线视频,色妞www精品视频,a天堂视频在线观看,熟女精品激情免费视频,午夜福利二区无码在线,午夜夜伦鲁鲁片免费无码,99成人福利免费视频
File:cn/goods2.htm
Method:query.table(columns,*where,*order,*top)
關(guān)鍵字 'and' 附近有語法錯誤。
select top 10 * FROM cocontent WHERE Status>0 and and TagIds like '%,3,%' ORDER BY Grade desc,Modified desc,ContentId desc
數(shù)據(jù)庫執(zhí)行錯誤
cn/xmls/goodsss.xmls
...
$sub SelectSDS(){
@TableDownload=$query(msds,download);
@TableDownload[GoodsCode]=@GoodsCode;
@FileName=@TableDownload.scalar(FileName,['{*GoodsCode =} and AreaId=1']);
$if(@FileName){
@texten=$file.readText($file.getMapPath(@FileName));
$return(@texten);
}
$write($empty);
}
//查詢產(chǎn)品en SDS
$sub SelectEnSDS(){
@TableDownload=$query(msds,download);
@TableDownload[GoodsCode]=@GoodsCode;
@FileName=@TableDownload.scalar(FileName,['{*GoodsCode =} and AreaId=2']);
$write.out(@FileName,1);
$if(@FileName){
@texten=$file.readText($file.getMapPath(@FileName));
$return(@texten);
}
$write($empty);
}
//新聞
$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(@...