Lol you said MS Access and GREAT in the same sentence. .:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com
-----Original Message----- From: Claude Schneegans [mailto:[email protected]] Sent: Saturday, June 13, 2009 1:15 PM To: cf-talk Subject: Re: Case Sensitive SQL >>Microsoft Access is terrible. Well, yet another legendary Access database bashing :-( Access database are GREAT for any small/medium web application. Most databases implement the string comparison to be case insensitive by default. They also have provisions to change it either globally or locally, and COLLATE is just one of them, not the simplest one. In Access, there is a very simple solution : the StrComp() function In your case, try WHERE strComp(password, '#from.passWord#', 0) = 0 Parameter 0 stands for "binary compare", 1 would be for case insensitve compare ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
