我要给数据库里存放东西,用insert 语句,提示有错误,我检查了n遍,觉得没有错误呀,可运行完程序后,老出现以下错误:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/rec_book/rec_article.asp,行 24
我得程序如下:
rti_source=request.form("source")
title=request.form("title")
auther=request.form("auther")
librarian=request.form("librarain")
article=request.form("article")
arti_date=request.form("date")
'response.write(title)
db="rec_data.mdb"
sql="insert into article (source,title,auther,librarian,article,date) '第24行values ('"&arti_source&"','"&title&"','"&auther&"','"&librarian&"','"&article&"','"&arti_date&"')"'第24行
set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath(db)
' set rs=server.createobject("ADODB.recordset")
conn.Execute(sql)
'set rs=nothing
conn.close
set conn=nothing
response.write"文章推荐成功!"
%>