Hello,
After successfully importing my entire MS SQL database and having the Pg
server up and flying, I decided to make a copy of my site and test
everything out. I went to the login screen, filled in my user name and
password and submitted. After several unsuccessful attempts, it dawned on
me what the problem was: I was entering my user name in all lower case,
while in the database it has mIxEd cAsE. So, I tried again, using the mixed
case. Boom! Login works.
Now, I know that the table names and columns are case sensitive, and I
already took care of all of those issues. But data? Case sensitive data??
I'm actually in shock over this one. Anyways, shock aside, is there some
way that I can make it not be case sensitive with the data?
While this is an 'okay' solution for a search form, I think it's insane to
have to resort to the following for a login query:
SELECT userid FROM tbl_user
WHERE user_name ILIKE '#form.user_name#'
AND user_psswd LIKE '#form.user_psswd#';
or this one:
SELECT userid FROM tbl_user
WHERE lower(user_name) = '#lcase(form.user_name)#'
AND lower(user_psswd) = '#lcase(form.user_psswd)#';
(Yes, I actually use <cfqueryparam /> in a real query... just didn't want to
type out the whole thing.)
Again, my question is, and I'm praying hard that the answer is a resounding
'YES!', but is there a way to make the data case INsensitive?
Thanks in advance,
Matt
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266476
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
