网页数据库动作查询问题
代码如下:<script language="vbscript">
<!--
sub ok_onclick
dim conn,sql,rs
set conn=createobject("adodb.connection")
conn="Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=F:\weiyuanxx\db1.mdb"
set rs=createobject("adodb.recordset")
sql="select * from user"
rs.open sql,conn,3,2
if oldpassword=rs("password") then
if newpass=okpass then
sql="update user set password='" & newpass & "'" & space(1) & "where" & "password='" & oldpass & "'"
conn.execute sql
else
msgbox "密码不正确请重新输入"
newpass=""
okpass=""
end if
else
msgbox "密码不正确请重新输入"
oldpass=""
end if
set conn=nothing
set rs=nothing
end sub
-->
问题是SQL语句执行不了。不支持此属性oldpass=""
请各位哥大姐多多指教。