修改页面为什么不能更新数据库呢?
<%
name=Request.form("name")
sex=Request.Form("sex")
b_year=Request.Form("b_year")
nation=Request.Form("nation")
clan=Request.Form("clan")
study=Request.Form("study")
graduate=Request.Form("graduate")
sp=Request.Form("sp")
e_sp=Request.Form("e_sp")
units=Request.Form("units")
ttoatp=Request.Form("ttoatp")
duty=Request.Form("duty")
dp=Request.Form("dp")
tel=Request.Form("tel")
fax=Request.Form("fax")
message=Request.Form("message")
email=Request.Form("email")
eresume=Request.Form("eresume")
grade=Request.Form("grade")
remark=Request.Form("remark")
ratify=Request.Form("ratify")
dim conn,connstr
on error resume next
'connstr="DBQ="+server.mappath("E:\home\sunrise-star\www\fashion\member\database\member.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
connstr="DBQ="+server.mappath("database\member.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
Set conn=Server.CreateObject("ADODB.CONNECTION")
conn.open connstr
dim rs,sql,sqlstmt
set rs=Server.CreateObject("Adodb.Recordset")
sql = "SELECT * FROM mem"
rs.open sql,conn,1,3
rs.addnew
sqlstmt="update mem"
sqlstmt=sqlstmt & " set name='" & name & "'"
sqlstmt=sqlstmt & " sex='" & sex & "'"
sqlstmt=sqlstmt & " b_year='" & b_year & "'"
sqlstmt=sqlstmt & " nation='" & nation & "'"
sqlstmt=sqlstmt & " clan='" & clan & "'"
sqlstmt=sqlstmt & " study='" & study & "'"
sqlstmt=sqlstmt & " graduate='" & graduate & "'"
sqlstmt=sqlstmt & " sp='" & sp & "'"
sqlstmt=sqlstmt & " e_sp='" & e_sp & "'"
sqlstmt=sqlstmt & " units='" & units & "'"
sqlstmt=sqlstmt & " ttoatp='" & ttoatp & "'"
sqlstmt=sqlstmt & " duty='" & duty & "'"
sqlstmt=sqlstmt & " dp='" & dp & "'"
sqlstmt=sqlstmt & " tel='" & tel & "'"
sqlstmt=sqlstmt & " fax='" & fax & "'"
sqlstmt=sqlstmt & " message='" & message & "'"
sqlstmt=sqlstmt & " email='" & email & "'"
sqlstmt=sqlstmt & " eresume='" & eresume & "'"
sqlstmt=sqlstmt & " grade='" & grade & "'"
sqlstmt=sqlstmt & " remark='" & remark & "'"
sqlstmt=sqlstmt & " ratify='" & ratify & "'"
sqlstmt=sqlstmt & " where name='" & name&"'"
set rs = conn.execute(sqlstmt)
reponse.write "恭喜!您已经注册成功."
reponse.write "<br>请根据我们的规定交纳会费,"
reponse.write "同时享受我们的会员权力."
reponse.write "<br><a href='index.asp'>返回主页面</a>"
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<html>
<head>
<title>会员申请表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body link="#000000" vlink="#000000" alink="#000000">
</body>
</html>
---------------------------------------------------------------------
以上就是编辑页面源代码,但是为什么不能更新数据库呢???