did you alter the field definition ? SQLite has a big issue when dealing
with columns whose type is altered. as a proof of concept, try deleting
your database and let web2py recreate it, you shouldn't incur again in any
problem.
On Sunday, February 16, 2014 6:06:25 AM UTC+1, A36_Marty wrote:
>
> Problem: When I send a recordset to a grid that contains a datetime
> field, I get the following error:
> <type 'exceptions.ValueError'> invalid literal for int() with base 10: '16
> 04:59:22'
>
> The field is defined as:
> Field('last_updated', 'datetime')
>
> The current datetime is written to the field with the following function:
> last_updated=datetime.datetime.utcnow()
>
> Looking in sqlite directly, I see the following value:
> 2014-02-16 04:59:22
>
> However, when I try to load the grid with that value in the column, I get
> the above error. If I empty the field to "" and reload the grid, it loads
> fine.
>
> Could someone point me in the right direction for working with datetimes
> in web2py... The proper way to store, retrieve them. Also, if the value
> I supplied above is invalid, why was it accepted by web2py's DAL?
>
> Many thanks in advance
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
