I've loaded a bunch of data into the DB, and some of the tables and rows
has the datetime field "0000-00-00"
That caused web2py admin > this app's database to raise an error because of
the datetime field:
"year is out of range"
(1) I tried to use filter_out on the field but it is not working. What can
I do for this error?
def filter_out_datetime(table, fields):
def check_datetime(self, dt):
if dt=='0000-00-00 00:00:00':
return ''
else:
return dt
for field in fields:
db[table][field].filter_out = lambda val, cdt=check_datetime: cdt(val)
(2) Is there a way to retrieve all fields of "datetime" type in web2py? I
have a number of such fields across the many tables. And may be adding
more...
(3) How do I use SQLCustomType for this use case?
Thank you!
--
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/d/optout.
