Microsoft OLE DB Provider for SQL Server 错误 '80040e14' 怎么办?
这个问题颇为头疼,我对MSSQL实在不熟悉,高手们请帮帮忙解决一下,不胜感激
ASP程序中出现这个错误提示
Microsoft OLE DB Provider for SQL Server 错误 '80040e14'
列名 'Growty' 无效。
相关代码
Function Get_Growty(UserIDValue)
err.clear
if trim(UserIDValue) = "" or not isnumeric(UserIDValue) then Get_Growty = 0 : exit function
dim tmp : tmp = Grow_AutoUpdate(UserIDValue)
sql = "select userlist.Grow,Grow.Growty from userlist inner join Grow on Userlist.Grow_Level = Grow.Grow_Level where UserList.id = '"&UserIDValue&"'"
set rstmp = conn.execute(sql)
if rstmp.eof and rstmp.bof then
rstmp.close
Get_Growty = 0 : exit function
else
Get_Growty = rstmp(1)
end if
rstmp.close
set rstmp = nothing
End Function