Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 30th, 2003, 10:27 AM
Registered User
 
Join Date: Jun 2003
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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
IIS username password problem r_1481 BOOK: Beginning ASP.NET 1.0 2 December 20th, 2011 01:41 AM
Problem with Forgotten Password retrieval Insel Haber ASP.NET 2.0 Basics 1 October 18th, 2006 04:01 AM
compare these date fields and compare and get the susanring Oracle 1 July 24th, 2006 04:58 PM
Compare dates [problem]... Varg_88 VB Databases Basics 3 August 20th, 2004 09:55 AM
problem with the password mpkrishna Classic ASP Basics 0 September 4th, 2003 02:48 AM





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