ASPCMS使用搜索 提示:【执行SQL语句错误】错误号:-2147217900

2024-11-18 05:49:01
推荐回答(1个)
回答1:

语法出错
sql="select ContentID,a.SortID,a.GroupID,a.Exclusive,Title,Title2,TitleColor,IsOutLink,OutLink,Author,ContentSource,ContentTag,Content,ContentStatus,IsTop,Isrecommend,IsImageNews,IsHeadline,IsFeatured,ContentOrder,IsGenerated,Visits,a.AddTime,a.[ImagePath],a.IndexImage,a.DownURL,a.PageFileName,a.PageDesc,SortType,SortURL,SortFolder,SortFileName,SortName,ContentFolder,ContentFileName,b.GroupID ,P_jiage from AspCms_Content as a,AspCms_Sort as b where a.LanguageID=1and a.SortID=b.SortID and ContentStatus=1 and TimeStatus=0 and a.SortID in (0,1,2,3,4,127,5,6,7,20,8,9,10,11,12,13,14,15,16,17,18,19,65,66,69,70,81,83,113,114,117,115,101,107,108,123,109,118,119,120,121,122,125) and Title like '%输入关键字%' order by ContentID desc"