db.define_table(
'route',
Field('city'),
Field('country_iso'))
db.define_table(
'order_bus',
Field('depart_from', db.route),
Field('arrive_to', db.route),
Field('date', 'date'),
Field('time', db.depature_times), # drop-down select time options
Field('no_of_passengers', db.tickets), # drop-down options to select
number of positions
Field('posted_on', 'datetime', readable=False, writable=False),
Field('posted_by', readable=False, writable=False))
db.order_bus.time.requires = IS_IN_DB(db, 'depature_times.id', '%(time)s',
zero=T('Select Time'))
db.order_bus.depart_from.widget = SQLFORM.widgets.autocomplete(request,
db.route.city, limitby=(0,10), min_length=2)
db.order_bus.arrive_to.widget = SQLFORM.widgets.autocomplete(request,
db.route.city, limitby=(0,10), min_length=2)
db.order_bus.depart_from.requires = IS_IN_DB(db, 'route.city', zero='')
db.order_bus.arrive_to.requires = IS_IN_DB(db, 'route.city', zero='')
db.order_bus.no_of_passengers.requires = IS_IN_DB(db, 'tickets.id',
'%(people)s', zero=T('Passengers'))
The route DB looks like this;
route.id route.city route.iso
1Washington DC US
2New York City US
3Miami US
4Atlanta US
Good day guys,
The above model is based on a form that I created. Everything works just
fine, except that when I submit the form, the depart_from and arrive_to
fields have a 0 value. How can I get those fields to display either the
route.id or route.city?
--
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.