View Single Post
  #1 (permalink)  
Old June 30th, 2003, 10:27 AM
eriastorga eriastorga is offline
Registered User
 
Join Date: Jun 2003
Location: Mexico, df, Mexico.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to eriastorga
Default problem with compare password

Hi!!
> I have a problem when compared the password from my database
> (SQL SERVER)and it's a char type. Then I try to compared with
> the input type (password).
>
> I'm insert the correct password, and donĀ“t passed to another
> page, because the comparation marked that the password is incorrect
>
> My Comparation is following:
>
>
> If Request("Action") = LoginButton Then
> Set DB = Connect()
> SQL = "SELECT CVE_ULSA,PASSWORD,NOMBRE,APELLIDO FROM
> ALUMNO WHERE CVE_ULSA=" & Request("Clave")
> Set RS = DB.Execute (SQL)
>
> If (RS.EOF And RS.BOF) Then
> Session (SiteID + "Authentication") = False
> Response.Redirect ("login.asp?Error=La+Clave+no+existe.")
> ElseIf RS("PASSWORD") <> Request ("Password") Then
> Session (SiteID + "Authentication") = False
> Response.Redirect
> ("login.asp?Error=Password+Invalido"+RS("PASSWORD" )+Request
> ("Password"))
> Else
> Session (SiteID + "Clave") = RS("CVE_ULSA")
> Session (SiteID + "Nombre") = RS("NOMBRE")
> Session (SiteID + "Apellido") = RS("APELLIDO")
> Session (SiteID + "Authentication") = True
> Response.Redirect ("welcome.asp")
> End If
> Response.write oRecordSet( "PASSWORD")
>
> End If
>
>
> Thanks, for your attention.