logon.asp is allowing user to type in uername and password
this goes to
checkstatus.asp which checks to see if username and password are correct. If password is password it redirects to changePassword.htm (I also tried changePassword.asp).
At changePassword.htm (.asp) the user types in old password, newPassword and newPassword2. This then goes to newPassword.asp which is trying to update the record if newPassword = newPassword2. I assumed I would be using Response.Form ("newPassword") to check for equality, but I get the error message "Object doesn't support this property or method Response.Form"
Here is the code:
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("chsTeachers.mdb")
Set rsUpdateEntry = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM TeacherInfo WHERE tID='" & strTeacher &"' AND tPassword='" & strPassword & "'"
rsUpdateEntry.CursorType = 2
rsUpdateEntry.LockType = 3
rsUpdateEntry.Open strSQL, adoCon
oldPassword = Response.Form ("oldPassword")
newPassword = Response.Form (newPassword)
newPassword2 = Response.Form (newPassword2)
strPassword = Session ("tPassword")
strTeacher = Session ("tID")
if rsUpdateEntry.EOF Then
Response.Redirect ("logon.asp")
Else if newPassword = newPassword2 Then
rsUpdateEntry.Fields("tPassword") = newPassword
rsUpdateEntry.Update
Response.Redirect ("menu.htm")
Else
Response.Redirect ("changePassword.htm")
End if
End if
What am I not getting? I have tried putting the Response.Forms in the if statements as well, but I can't get it to like them their either.