[求助]数据库的添加错误
请大侠们看一下 小弟就是不明白哪些语句错误
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/chengji/addcourse.asp, 第 29 行
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Maxthon)
POST 39 ??? /chengji/addcourse.asp
txtcoursename=12&btnsubmit=%B1%A3%B4%E6
<%
Dim cnn, rst, sSQL
If Session("UserName")="" Or Session("Level") < 2 Then
Response.Write "你无权访问本页面!"
Response.End
End If
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.ConnectionString = "PROVIDER=microsoft.jet.oledb.4.0;DATA SOURCE=" & server.mappath("Date\date.mdb")
cnn.Open
if request.form ("txtcoursename") <> "" then
coursename = request.form ("txtcoursename")
ssql = "insert courses(course_name) values (' " & coursename & " ')"
cnn.execute ssql, , adcmdtext
end if
set rst =cnn.execute("courses", , adcmdtable)
%>
[此贴子已经被作者于2007-5-15 12:32:19编辑过]