I have some code that was working before but I can't quite pinpoint why
it's not working now. In any case it's a time field in a table and when I
insert into this field the database shows '00:00:00' in the field (by
looking at the record in an SQLite admin tool)
Field('start_time','time', default='2:00PM'),
I have a form where this value is inserted along with other form values.
The insert statement looks like:
form.vars.id = db.sometable.insert(**db.sometable._filter_fields(form.vars
))
I have inspected form.vars in the debugger immediately before this
statement is executed and I can see form.vars.start_time has a string value
such as '3:00PM'. The insert statement executes with no error and the
record is inserted in the database but the time field shows as
00:00:00. This further causes an error when trying to view the database
record from web2py:
ValueError: invalid literal for int() with base 10: '00PM'
Any idea why the time is not inserting properly and how to fix it? Is the
time string in the wrong format?
--
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.
