I am not familiar with encrypt() in mysql. If you show me how you use it in mysql, I can see how to do with dal.
On Mar 11, 9:15 am, Vlad Janicek <[email protected]> wrote: > Hey there People, > > I have a question, lets shay that I need to create an users table that > some other systems connect to and when these systems check for users, > only use the MySQL encrypt() function. > > The model would be something like this: > > # My model > db.define_table('users', > Field('domain', db.domains, requires = IS_NOT_EMPTY()), > Field('email', requires = IS_EMAIL()), > Field('password', 'password', requires = IS_NOT_EMPTY()), > Field('quota', requires = IS_NOT_EMPTY()), > ) > > # My CRUD sentence > form = crud.create(db.users, message='email has been added > successfully') > > Im using in in a very simple way and it works if it was a standalone > app but, I need web2py to enforce MySQL encrypt() every time I add or > query for a record. I can do it manually but it would stop me from > using CRUD. > > What would be the best approach?? > Thanks a lot for your help... > vj
