Hello, We have a legacy Cold Fusion app running off a MS SQL db server and plan to gradually move functionality from CF to web2py. Both systems will run concurrently, accessing the same db. Thanks to the web2py (awesome piece of software! thank you Massimo and the other contributors!) DAL, we can access the legacy database no problem.
The db has a User table with fields like: FirstName, LastName, Email, Password etc. The field names do not match the names used in web2py auth.settings.table_user_name (first_name, last_name, email, passwd etc.) We would love to use web2py Auth for login/register/profile forms, decoration of controller actions with @auth, and handling password resets. It looks like there will be a lot of customization of the Auth settings to get it to work with our legacy database. The only alternative I can think of is not using Auth at all. Everything custom - our own login form, register page, password reset - and we don't get @auth. decorators. What would you recommend? I'm guessing this has been done before but I haven't found a solution. Is there another way of doing this that makes more sense? Thanks in advance, Jerry.
