Record Verification

Results 1 to 2 of 2

Thread: Record Verification

  1. #1
    DeusX Guest

    Default Record Verification

    Help!!! :)<BR><BR>I&#039;m trying to create a practice login database. I have the database correct however when I try to verify the password it doesn&#039;t verify it correctly. Where is my code wrong?<BR><BR>Set UName = Request("LoginName")<BR>Set UPass = Request("LoginPass")<BR><BR>SQL = "SELECT * FROM ManagementLogins WHERE UserName LIKE &#039;" + UName + "&#039;"<BR><BR>IF NOT ((UName = "") OR (UPass = "")) Then<BR><BR> Set RS = Server.CreateObject("ADODB.RecordSet")<BR> RS.Open SQL, connection<BR> <BR> IF NOT (UPass = RS("Password")) Then<BR><BR> Response.Redirect "InvalidLogin.asp"<BR> Else<BR><BR><BR><BR>And the code continues...can anyone assist me as to why the last IF statement is returning true when the all of the information is accurate?

  2. #2
    Join Date
    Dec 1969

    Default RE: Record Verification

    try casting the RS variable into a string with CStr() - it may help. also don&#039;t use LIKE in the SQL string<BR><BR>j

Posting Permissions

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