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.


Reply via email to