我写了一个修改密码的ASP程序,,,可是老是有错误提示!!请高手指点!!

来源:百度知道 编辑:UC知道 时间:2024/05/29 12:19:25
<%
dim name,password,pwd
name=request.form("stuid")
password=request.form("formpwd1")
pwd=request.form("newpwd")
dim exec,conn,rs
exec="updata check set password=request.form("newpwd") where'name='"&session("stuid")&"' and pwd='"&password&"'"
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("studentmanger.mdb")
set rs=server.createobject("adodb.recordset")
rs.open exec,conn
if not rs.eof then
rs.Close
conn.Close

%>
错误类型:
Microsoft VBScript 编译器错误 (0x800A0401)
语句未结束
/text/change.asp, line 7, column 47
exec="updata check set password=request.form("newpwd") where'name='"&session("stuid")&"' and pwd='"&password&"

这个sql语句有问题
exec="updata check set password=request.form("newpwd") where'name='"&session("stuid")&"' and pwd='"&password&"'"
改写成

exec = "updata check set password='" & pwd & "' where name='" & session("stuid") & "' and pwd='" & password & "'"