my db.py
db.define_table('oco',
Field('created_on', 'datetime', required=True,label='Data'),
...
...
db.oco.created_on.requires=[IS_DATE(format=T('%Y/%m/%d %H:%M:%S'),
error_message=T("Formato pretendido aaaa/mm/dd HH:MM:SS"))]
I create a record with created_on set to
2013/09/25 09:54:24
I get this error
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
Traceback (most recent call last):
File "C:\web2py2\gluon\restricted.py", line 209, in restricted
exec ccode in environment
File "C:/web2py2/applications/empre/controllers/default.py"
<https://apps.cires.pt/admin/default/edit/empre/controllers/default.py>,
line 1120, in <module>
File "C:\web2py2\gluon\globals.py", line 186, in <lambda>
self._caller = lambda f: f()
File "C:/web2py2/applications/empre/controllers/default.py"
<https://apps.cires.pt/admin/default/edit/empre/controllers/default.py>,
line 486, in index
for oco in db(db.oco.rel_trab.contains(trab.id)).select():
File "C:\web2py2\gluon\dal.py", line 8766, in select
return adapter.select(self.query,fields,attributes)
File "C:\web2py2\gluon\dal.py", line 2094, in select
return super(SQLiteAdapter, self).select(query, fields, attributes)
File "C:\web2py2\gluon\dal.py", line 1594, in select
return self._select_aux(sql,fields,attributes)
File "C:\web2py2\gluon\dal.py", line 1559, in _select_aux
self.execute(sql)
File "C:\web2py2\gluon\dal.py", line 1671, in execute
return self.log_execute(*a, **b)
File "C:\web2py2\gluon\dal.py", line 1665, in log_execute
ret = self.cursor.execute(*a, **b)
File "c:\Python27\lib\sqlite3\dbapi2.py", line 63, in convert_date
return datetime.date(*map(int, val.split("-")))
ValueError: invalid literal for int() with base 10: '25 00:00:00'
I see that in my sqlite file the date was set to 2013-09-25 00:00:00
instead of 2013/09/25 09:54:54
What i wrong?
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
