SOS- - 求助.(SQL Server]列名 \'****\' 无效)
错误提示:------------------------------------------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers \'80040e14\' 列名 \'News_infotype\' 无效。 \\Bns\\AdminNews_add.asp, line 49
------------------------------------------------------------------------------------------------
以下是 line 49(红色部分)
------------------------------------------------------------------------------------------------
Set rs = Server.CreateObject(\"ADODB.Recordset\")
rs.Open \"Select
News_class,News_title,News_color,News_content,News_date,News_Bns_class,News_city,News_Bns_id,News_infotype from
Bns_News\",conn,1,3
rs.Addnew
rs(\"News_class\")=News_class
rs(\"News_title\")=News_title
rs(\"News_color\")=News_color
rs(\"News_content\")=News_content
rs(\"News_date\")=Now()
rs(\"News_Bns_class\")=Bns_bclass
rs(\"News_city\")=Bns_city
rs(\"News_Bns_id\")=Session(\"Bns_id\")
rs(\"News_infotype\")=infotype
rs.Update
rs.Close
Set rs=Nothing
conn.close
Set conn=Nothing
------------------------------------------------------------------------------------------------
请大家帮助一下.1 ==自已坐回沙发==
5 (已解决=解决左)2 被你玩晒喇~~ 列名 'News_infotype' 无效说明你的那个表中不存在这个列! 急事 请联系QQ 190527312 一看错误就应该想到少了某个列名啦。真系俾你玩嗮啦
页:
[1]