error use SQLLiteral

[perol.chen_零下一度]

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

[Anand]

On 12-Nov-07, at 11:37 AM, perol.chen_零下一度 wrote:

>
> 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")

Probably there is a bug in web.py.

Use the following as work around.

web.query('UPDATE user WHERE name=$name lastlogintime=$nowtime,
loginnum=loginnum+1, lastloginip=web.ctx.ip, vars=locals())

[dou...@gmail.com]

I have found that SQLLiteral does not work for me, so I have had to
avoid using web.update for a lot of cases, and use Anand's method more
often.