%
id = Request("id")
newpassword = Request("password")
newpasswordtemp = Request("passwordtemp")
If newpassword > newpasswordtemp Then
Response.Write "center>對不起,密碼未能確認,請重新輸入!/center>"
Response.End
End If
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("userinfo.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" DBPath
Set rs = Server.CreateObject("ADODB.Recordset")
sql="update userinfo set 密碼='" newpassword "' where id="id
rs.Open sql, conn, adOpenDynamic, adLockPessimistic
%>
[1]