Hi,

I have the following query:

>>>web.update('posts', where='id=$post_id', 
>>>last_modified=web.db.SQLLiteral('NOW()'), vars=locals())
<sql: 'UPDATE posts SET last_modified = NOW() WHERE id=2'>

So, it looks good. However, when I actually use this, it sets
last_modified to null and reports this error:

/Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/site-
packages/web/db.py:338: Warning: Out of range value adjusted for
column 'last_modified' at row 1
  out = cur.execute(sql_query.s, sql_query.v)
0L

Anyone know what's going on?

Thanks,

-dougal


--~--~---------~--~----~------------~-------~--~----~
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