更新数据库出现的错误问题,挺简单的,可就是调不出来。

 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
做程序员这点,呵呵,

Published At
Categories with Web编程
comments powered by Disqus