Matt, There's no way that I know of. Just my 2 cents, but I think that case sensitivity with data is a wonderful thing - especially when it comes to user authentication. (http://en.wikipedia.org/wiki/ Password_strength)
I think you'll probably have to handle that within the query - or just change the username and password to lowercase. Jon On Jan 12, 2007, at 11:46 PM, Matt Quackenbush wrote: > 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:266482 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4