Claude Schneegans wrote: > >>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
I have to agree with Claude. I made a lot of money off of connecting to Access since it was cheap and easy to deal with. It was about all we had when I started (cf1.5). It isn't the best one to use now days, but it really never let me down. Now I use the industrial strength tools, but there is no need to bash it. It still works pretty well for smaller sites, plus a lot of office people who don't know DBMS find it easy to use. On a different subject, I would suggest saving the hash of the password rather than the alphanumeric string, but that might not be needed in your case. Good luck, Roger -- Visit http://www.misshunt.com/ for fun and creative items including the famous Clean/Dirty dishwasher magnet, now available in velcro. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:323489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
