Question

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

错误号：-2147217900
错误描述：内存溢出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

Answer 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"

追问

我发现问题所在了，是网站发布的内容含有日文字符，ASPCMS好像不支持导致出错。