what is wrong?
<!--#include file="connection.asp"-->
<!--#include file="chkuser.asp"-->
<%
dim CInfoSQL
CInfoSQL="SELECT * FROM UserInfo WHERE userName = '" & CStr(Session("username")) & " ' "
dim CInfoData
Set CInfoData = Server.CreateObject("ADODB.Recordset")
call CInfoData.Open( CInfoSQL,conn )
On Error Resume Next
IF CInfoData.EOF Then
Session("SysMessage")=":( Sorry, your password is wrong!"
ELSE
If Request("newpass") = "" or Request("repass") = "" then
Session("SysMessage")="输入信息不完整!"
Else
If Request("newpass") = Request("repass") Then
dim Edit
Edit="UPDATE UserInfo SET password='" & CStr(Request("newpass")) & "' WHERE userName='" & CStr(Session("username")) & "'"
Call conn.Execute(Edit)
Session("SysMessage")="Done!"
Else
Session("SysMessage")="密码不一致!"
End if
End if
END IF
Call CInfoData.Close()
Call conn.Close()
Call Response.Redirect("profile.asp")
%>
----End of Code----
为什么密码不能被修改?