I figured it out using the compare function after getting a valid username
and password from the db. This will check a username and password for case
sensitivity.
<CFIF (login.recordcount eq 0)
or
(compare(form.password, login.password) neq 0)
or
(compare(form.username, login.username) neq 0)
>
...bad password. try again.
--
Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000
> > I'm using Access. Any ideas with that or would I need to use
> > the solution you provided below with nested loops?
>
> There may be something for this in Access, but I don't know enough about
> Access to tell you.
>
> > Are all password protected sites done with Cold Fusion
> > non-case sensitive, or is a lot of special processing done
> > when Access is the db?
>
> I suspect that most sites don't use case-sensitive passwords.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
