如何从列表.tuples然后提交值？

Question

<form name="cnf" action="{{=URL('default','dashboard')}}" method="post" onsubmit="return showcnf()" >
    <select name="c_area">
        <option value="">Select Company</option>
        <option value="Headmasters Salon Pvt. Ltd.">Headmasters Salon Pvt. Ltd.</option>
    </select>
    <select name="c_loc">
        <option value="">Select Location</option>
        <option value= 1>Chandigarh</option>
    </select>
    </br>
    <input type="submit" value="go">
</form>

我想用tuple/list代替select。有什么办法吗？ 我试过一些东西：

def dropdowan():
    list = []
    for row_l in db( (db.tracker.client_manager==auth.user.email)  ).select():
        list.append(row_l.company)

    abc=set(list)
    return dict(form=abc)

我正在从数据库中获取值。现在我想把表格放进去。你知道吗

Answer 1

你可以这样摆桌子：

db.define_table('your_table_name',
    Field('select_1', requires=IS_IN_SET(['option_1', 'option2', 'option3'])),
    Field('select_2', requires=IS_IN_SET(['option_1', 'option2', 'option3']))
    Field('another_field', 'text'))

然后你可以使用web2py内置的SQLFORM.widgets.options.widget来为你施展魔法。你知道吗

Answer 2

嗨，我想了想。希望一切都会好起来

 def dropdowan():
        list = []
        clist=[]
        for row_l in db( (db.tbl.field==auth.user.email)  ).select():
            list.append(row_l.f1)
            clist.append(row_l.f2)

        abc=set(list)
        city=set(clist)
        form = SQLFORM.factory(Field('select_company', requires =  IS_IN_SET(abc)),Field('select_city', requires =  IS_IN_SET(city)))
        if form.accepts(request,session):
            session.company = form.vars.select_company
            session.loc = form.vars.select_city

            #redirect=dashboard()
            redirect(URL('dasboard'))

        return dict(form1=form)