p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Databases (http://p2p.wrox.com/forumdisplay.php?f=62)
-   -   problem with compare password (http://p2p.wrox.com/showthread.php?t=1103)

eriastorga June 30th, 2003 10:27 AM

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.


All times are GMT -4. The time now is 05:00 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.