I've been having a heck of a time trying to figure out how to make a
simple drop down list from a table in the database.
What I would like to do is have a drop down list populated by the
table information and when a person selects that item from the drop
down I want it to go to a page that pulls up all of those types of
items.
I've seen reference to IS_IN_SET() and IS_IN_DB() but it doesn't make
much sense to me since there are a lack of examples.
This is what I have so far on it.
def get_services()
services = db(db.services.name>0).select(orderby=db.services.name)
form = SQLFORM.factory(SQLField('name', label='Select a
service',requires=IS_IN_SET(services)))
return dict(form=form)
default/get_services.html
{{=form}
This does create a drop down but it has a bunch of extra information
about query and lambda which I don't need and only displays about half
of the names in the table. I just need the name and the ID like a
normal dropdown list with auto submit.
Has anyone a reference to something like this?
Thanks,
David
