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.