Hi all,
Please could you tell me how i could verify if a password being posted from
another page
has the exact same case as the password in the database.
Eg password: Orange
But if enter orangE it evaluates to being true.
Please could you tell me how to determine if the password matches the
TECTED]
Sent: Friday, January 26, 2001 2:18 PM
Subject: URGENT: Case Question
Hi all,
Please could you tell me how i could verify if a password being posted
from
another page
has the exact same case as the password in the database.
Eg password: Orange
But if enter orangE it evaluates to being
Javed,
Using SQL server? Search the archives for this week- we just went through
that with some great answers.
The simplest was using the CONVERT function to make the terms varbinary
datatype, then comparing them.
Mark
[EMAIL PROTECTED]
Hi all,
Please could you tell me how i could verify
Take a look at the COMPARE() function. It does a case sensitive comparison
of two text strings.
Evan
-Original Message-
From: Javed Mushtaq [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 2:18 PM
To: CF-Talk
Subject: URGENT: Case Question
Hi all,
Please could you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Javed,
You have two options:
a) get a database server that can do case sensitive searches (Oracle
by default, MS SQL by choice)
or
b) Retrieve all usernames from the db that match and then do:
cfif comparenocase(password1, password2)
Instead of comparing in SQL, try grabbing the password according to
username, and comparing it in ColdFusion
cfif Compare(form.password,query.password)
!--- authentication fails ---
cfelse
!--- authentication passes ---
/cfif
--
Billy Cravens
HR Web Development, Sabre
[EMAIL
PROTECTED]
Date: Friday, January 26, 2001 6:39 PM
Subject: URGENT: Case Question
Hi all,
Please could you tell me how i could verify if a password being posted from
another page
has the exact same case as the password in the database.
Eg password: Orange
But if enter orangE it evaluates to being true
7 matches
Mail list logo