Password change and Store in Database

Results 1 to 2 of 2

Thread: Password change and Store in Database

  1. #1
    Join Date
    Dec 1969

    Default Password change and Store in Database

    Microsoft][ODBC Microsoft Access Driver] Field &#039PersonalInfo.Password&#039 cannot be a zero-length string. <BR><BR>/ChangePassword.asp, line 64 <BR><BR>This is the error i am getting...Please Help. Let me know what mistake i am making.<BR><BR><BR><BR>&#060;%<BR><BR> Password = request.form("Password")<BR><BR> NewPassword = request.form("NewPassword")<BR> ConfirmNewPassword = request.form("ConfirmNewPassword")<BR><BR> <BR> NewPassword = trim(NewPassword)<BR><BR> ConfirmNewPassword= trim(ConfirmNewPassword)<BR><BR> <BR><BR> if NewPassword= ConfirmNewPassword then<BR><BR> set objConn = CreateObject("ADODB.Connection")<BR> set rstUserRecord = CreateObject("ADODB.Recordset")<BR><BR> "FILEDSN=timesheetdatabase.dsn"<BR><BR> strSQL1= "Update PersonalInfo set Password=&#039" & NewPassword &_<BR> "&#039 where LoginName=&#039" & session("LoginName") & "&#039" <BR> strSQL1, objConn, 2, 2 <BR> <BR> else<BR> response.write "&#060;H3&#062;Sorry Passwords do not match. Please Re-enter your password."<BR> end if <BR><BR><BR>%&#062;

  2. #2
    Join Date
    Dec 1969

    Default RE: Password change and Store in Database

    Do u checked whether the new password is empty? if u want to make sure whether ur sql statement is correct, u can write <BR>response.write strSQL1 <BR> try it and see

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts