错误类型： Microsoft OLE DB Provider for SQL Server (0x80040E14) 列名 'False' 无效。 /Inc/Mc_Functi

Question

InfoID,ChannelID,ChannelDir,ClassID,Title,FontColor,FontType,Content,PicUrl,IsHtml,HtmlFileUrl from Cl_Article where Deleted=False and Status=1 and PicUrl<>''"
Case 2
sqlPic=sqlPic & " InfoID,ChannelID,ChannelDir,ClassID,SoftName + ' ' + SoftVersion as Title,FontColor,FontType,Intro,PicUrl,IsHtml,HtmlFileUrl from Cl_Soft where Deleted=False and Status=1 and PicUrl<>''"
Case 3
sqlPic=sqlPic & " InfoID,ChannelID,ChannelDir,ClassID,PhotoName,FontColor,FontType,Intro,PicUrl,IsHtml,HtmlFileUrl from Cl_Photo where Deleted=False and Status=1 and PicUrl<>''"
Case 4
sqlPic=sqlPic & " InfoID,ChannelID,ChannelDir,ClassID,MovieName,FontColor,FontType,Intro,PicUrl,IsHtml,HtmlFileUrl from Cl_Movie where Deleted=False and Status=1 and PicUrl<>''"
Case 5
sqlPic=sqlPic & " InfoID,ChannelID,ChannelDir,ClassID,ProductName,FontColor,FontType,Intro,PicUrl,IsHtml,HtmlFileUrl from Cl_Product where Deleted=False and Status=1 and PicUrl<>''"
case else
sqlPic=sqlPic & " InfoID,ChannelID,ChannelDir,ClassID,Title,FontColor,FontType,Content,PicUrl,IsHtml,HtmlFileUrl from Cl_Article where Deleted=False and Status=1 and PicUrl<>''"
End Select
if sChannelID>0 then sqlPic=sqlPic & " and ChannelID="&sChannelID&" "
if sClassID>0 then
set tClass=Cl.Execute("select ClassID,Child,ParentPath,arrChildID from Cl_Class where ChannelID="&sChannelID&" and ClassID=" & sClassID)
if not(tClass.bof and tClass.eof) then
if tClass(1)>0 then
sqlPic=sqlPic & " and ClassID in (" & tClass(3) & ")"
else
sqlPic=sqlPic & " and ClassID=" & sClassID
end if
else
sqlPic=sqlPic & " and ClassID=" & sClassID
end if
set tClass=Nothing
end if
if sSpecialID>0 then sqlPic=sqlPic & " and SpecialID Like '%," & SpecialID & ",%'"
if IsHot=True then sqlPic=sqlPic & " and Hot=True "
if IsElite=True then sqlPic=sqlPic & " and Elite=True "
if IsSqlDataBase=1 then
sqlPic=sqlPic & " order by OnTop Desc,UpdateTime desc,InfoID desc"
Else
sqlPic=sqlPic & " order by OnTop Asc,UpdateTime desc,InfoID desc"
End if
Set rsPic= Server.CreateObject("ADODB.Recordset")
[519行] OpenConn : rsPic.open sqlPic,Conn,1,1
（字数不够，如果有办法解决，请于41547342联系！）
此程序系下载的整站程序，由ACCESS转为SQL后出现这种问题，ACCESS状态下基本正常。转为SQL后后台可以正常登录，首页无法链接，提示列名“FALSE” 无效。
查找表中有“FALSE”列名的数据库中的表，经查无。初步认为是SQL中数据类型的问题，可能是SQL无法识别FALSE数据，但本人系ASP、SQL菜鸟，找不到在什么位置出现的问题。请高手相助。

Answer 1

是不是你的Deleted类型不对,不是布尔值的,你把False改为0试试~
其实是简单的办法是把你最后执行的sql语句打印出来,直接复制到Access里面去执行一下就知道了~~~

---------------你应该使用追问
如果是sql里面就简单了,false是关键字,你应该加[] 如:
select [False] from table where [False]='dfsdf'

Answer 2

表中没有这个 Passport 或这是SQ的语句在格式上有错