1
2if request.form("name")="" then
3response.redirect "updata.htm"
4
5else
6Set Myconn=Server.CreateObject("ADODB.Connection")
7Myconn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("studentdb.mdb")
8
9sql="updata student set (email='"& request.form("email")&"' ,tel='"&request.form("tel")&"' , address='"& request.form("address")&"') where name='"&request.form("name")&"'"
10
11Myconn.Execute (sql)
12
13response.write("更新完成!")
14
15Myconn.close
16Set Myconn=Nothing
17
18end if
19
错误类型:Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
/namoweb/Myweb/student/updataction.asp, 第 11 行
Myconn.Execute (sql) 这一行有错。
各位大哥请赐教,俺感谢万分。
---------------------------------------------------------------
updata应为update
---------------------------------------------------------------
就是嘛,
updata 换成update
做程序员这点,呵呵,