I tried this: id=db.auth_user.insert( 'email':myemail, 'password':(db.auth_user.password.validate(mypassword)[0]), 'first_name':myname)
I get a syntax error at the first ':' myemail, mypassword and myname are string variables and are populated correctly. In my original statement, putting field names in quotes didnt help. When I tried this - id=db.auth_user.insert( 'email'=myemail, 'password'=(db.auth_user.password.validate(mypassword)[0]), 'first_name'=myname) I get this error: SyntaxError: keyword can't be an expression On Monday, May 6, 2013 11:13:39 PM UTC+5:30, 黄祥 wrote: > > please use ' for string data type > e.g. > db.auth_user.insert('email' : 'mye...@gmail.com <javascript:>', > 'password' : db.auth_user.password.validate('mypassword')[0], 'first_name' > : 'myname') > > best regards > > On Monday, May 6, 2013 1:11:02 PM UTC-4, vikas gupta wrote: >> >> I am trying this and I am getting errors: >> >> id=db.auth_user.insert( email=myemail, >> password=(db.auth_user.password.validate(mypassword)[0]), first_name=myname) >> >> I get this error: >> TypeError: character mapping must return integer, None or unicode >> >> File >> "/home/www-data/web2py/applications/trotez/controllers/default.py", line >> 171, in userRegister >> id=db.auth_user.insert( email=myemail, >> password=db.auth_user.password.validate(mypassword)[0], first_name=myname) >> File "/home/www-data/web2py/gluon/dal.py", line 8514, in insert >> ret = self._db._adapter.insert(self, self._listify(fields)) >> File "/home/www-data/web2py/gluon/dal.py", line 1199, in insert >> query = self._insert(table,fields) >> >> Something I am doing wrong? >> >> >> On Friday, April 29, 2011 12:56:06 AM UTC+5:30, 黄祥 wrote: >>> >>> yes, u right, ron, there is a mistaken on my field value, thanks for >>> show me my wrong code, it's work right now. thank you all for your pointer. >>> >>> On Fri, Apr 29, 2011 at 12:10 AM, ron_m <ron.m...@gmail.com> wrote: >>> >>>> email of a.a.com is not a valid email address according to your code. >>>> I am not sure if there is any validation during login >>>> >>> >>> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.