|
 |
access_asp thread: Can I make Access text fields case sensitive?
Message #1 by cjallen54@h... on Mon, 17 Mar 2003 10:24:43
|
|
I have a User Id table, which includes a password field. I want my
passwords to be case sensitive, but it's not. The values are stored with
mixed case. I can't find anything about Access that will make it enforce
case sensitive selects. Is it a property of Access or something I need to
add to the ASP select statement?
Message #2 by "Josh Katsaros" <katsarosj@y...> on Tue, 18 Mar 2003 04:55:18
|
|
Use "lcase" to convert your fields to lower case, then do your comparison.
> I have a User Id table, which includes a password field. I want my
p> asswords to be case sensitive, but it's not. The values are stored with
m> ixed case. I can't find anything about Access that will make it enforce
c> ase sensitive selects. Is it a property of Access or something I need
to
a> dd to the ASP select statement?
Message #3 by "Enzo Zaragoza" <enzaux@g...> on Tue, 18 Mar 2003 13:15:07 +0800
|
|
In VB you can make use of string compare (StrComp) which you can compare them in binary therefore
making it case sensitive. May be you can take a look into this. please tell me if it worked or not. I'm
curious also if it is possible.
Thanks,
enzo
-----Original Message-----
From: Josh Katsaros [mailto:katsarosj@y...]
Sent: Tuesday, March 18, 2003 4:55 AM
To: Access ASP
Subject: [access_asp] Re: Can I make Access text fields case sensitive?
Use "lcase" to convert your fields to lower case, then do your comparison.
> I have a User Id table, which includes a password field. I want my
p> asswords to be case sensitive, but it's not. The values are stored with
m> ixed case. I can't find anything about Access that will make it enforce
c> ase sensitive selects. Is it a property of Access or something I need
to
a> dd to the ASP select statement?
|
|
|
View Cart
