I use code below update userinfo when user login:

web.update('users',where="name=
$name",vars=d,lastlogintime=nowtime,loginnum=web.SQLLiteral('loginnum
+1'),lastloginip=web.ctx.ip)

but i get an error:
"Incorrect integer value: 'loginnum+1' for column 'loginnum' at row
1")

I don't kwow should i change my code , I want the column loginnum add
1 when user login

Thanks


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web.py" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to