Re: [web2py] Re: MySQL, encrypt() and CRUD

2011-03-11 Thread Juan Hernandez
Thanks a lot Massimo, I'll let you know what happens vj On Fri, Mar 11, 2011 at 12:17 PM, Massimo Di Pierro wrote: > You can do it with dal.SQLCustomType > > If you cannot find a useful example, let me know and I will write one. > > On Mar 11, 10:13 am, Juan Hernandez wrote: >> In MySQL would g

[web2py] Re: MySQL, encrypt() and CRUD

2011-03-11 Thread Massimo Di Pierro
You can do it with dal.SQLCustomType If you cannot find a useful example, let me know and I will write one. On Mar 11, 10:13 am, Juan Hernandez wrote: > In MySQL would go something like this > > #Insert > insert into users (domain, email, password, quota) values (1, > '...@x.com', ENCRYPT('mypas

Re: [web2py] Re: MySQL, encrypt() and CRUD

2011-03-11 Thread Juan Hernandez
In MySQL would go something like this #Insert insert into users (domain, email, password, quota) values (1, 'x...@x.com', ENCRYPT('mypass'), '101010'); # mysql> select * from users; | 3 | 1 | x...@x.com | j57VHP.kk4c.o | 101010 | 1 row in set (0.00 sec) and reading MySQL's docs I saw this:

[web2py] Re: MySQL, encrypt() and CRUD

2011-03-11 Thread Massimo Di Pierro
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 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 sy