Have you tried just displaying the form in your view using {{=form}}. Then add a requires=IS_IN_DB to the fields in your model. I'd do this just to make sure that SQLFORM.factory is working as expected. Make sense?
http://web2py.com/books/default/chapter/29/07/forms-and-validators#Database-validators -Jim On Tuesday, August 21, 2018 at 11:34:23 AM UTC-5, Rodrigo Gomes wrote: > > i really think its a bug in form.factory, i tried modify by the controller > too, like > form.element(_id=no_table_cities).update(_class="selectpicker") > > and no sucess. > > terça-feira, 21 de Agosto de 2018 às 13:31:38 UTC-3, Rodrigo Gomes > escreveu: >> >> @auth.requires_login() >> def students(): >> form = form=SQLFORM.factory(db.person, db.address) >> >> cities_list = db(db.cities.id>0).select(db.cities.ALL) >> address_type_list = db(db.address_type.id>0).select(db.address_type.ALL) >> person_list = db(db.person.id>0).select(db.person.ALL) >> >> >> if form.process().accepted: >> id = db.person.insert(**db.person._filter_fields(form.vars)) >> form.vars.person=id >> id = db.address.insert(**db.address._filter_fields(form.vars)) >> redirect(URL('default','students')) >> response.flash='Form Submetido com sucesso!' >> elif form.errors: >> print(form.errors) >> print(form.vars) >> else: >> print('please fill out the form') >> return dict(form=form, cities_list=cities_list, >> address_type_list=address_type_list, >> person_list=person_list) >> >> >> terça-feira, 21 de Agosto de 2018 às 10:10:39 UTC-3, Peng Wang escreveu: >>> >>> How did you define your cities_list? >>> >>> On Thursday, August 16, 2018 at 4:39:35 PM UTC-7, Rodrigo Gomes wrote: >>>> >>>> >>>> Good evening, folks, I've come here to unveil a mystery, I'm developing >>>> an application with web2py, (framework that I use about 3 years ago) >>>> >>>> I am using sqlform.factory, passing 2 tables, being that I do this to >>>> fill in a single form, table, person and address, for better understanding >>>> follows my controller, >>>> >>>> >>>> @auth.requires_login() >>>> def students(): >>>> form = form=SQLFORM.factory(db.person, db.address) >>>> >>>> if form.process().accepted: >>>> id = db.person.insert(**db.person._filter_fields(form.vars)) >>>> form.vars.person=id >>>> id = db.address.insert(**db.address._filter_fields(form.vars)) >>>> response.flash='Form Submetido com sucesso!' >>>> >>>> elif form.errors: >>>> print(form.errors) >>>> else: >>>> print('please fill out the form') >>>> >>>> >>>> >>>> >>>> if it helps, this is my model, the tables and their relationships, >>>> >>>> db.define_table("person", >>>> Field("name", "string", length=50), >>>> Field("cpf", "string", length=11), >>>> Field("birthday", "date", length=11), >>>> Field("email","string", length=40), >>>> Field("registration_date","date", length=40) >>>> ) >>>> >>>> db.define_table("cities", >>>> Field("name", "string"), >>>> Field("state","reference state") >>>> ) >>>> >>>> db.define_table("address_type", >>>> Field("type","string",length=100), >>>> ) >>>> >>>> db.define_table("address", >>>> Field("number","integer"), >>>> Field("public_place","string"), >>>> Field("cep","string",length=15), >>>> Field("complement","string"), >>>> Field("cities",'reference cities'), >>>> Field("address_type",'reference address_type'), >>>> Field("person",'reference person', writable=False,readable=False) >>>> ) >>>> >>>> >>>> >>>> >>>> This is my view >>>> >>>> <form action="#" class="form-material" enctype="multipart/form-data" >>>> method="post"> >>>> <div class="form-group"> >>>> <div class="col-md-12 m-b-20"> >>>> <!--form.custom.widget.name --> >>>> <input class="form-control" id="no_table_name" name="name" >>>> type="text" placeholder="nome"> >>>> </div> >>>> <div class="col-md-12 m-b-20"> >>>> <!--form.custom.widget.cpf --> >>>> <input class="form-control" id="no_table_cpf" name="cpf" >>>> type="text" placeholder="cpf"> >>>> </div> >>>> >>>> <div class="col-md-12 m-b-20"> >>>> <!--form.custom.widget.email --> >>>> <input class="form-control" id="no_table_email" >>>> name="email" type="text" placeholder="email"> >>>> </div> >>>> >>>> <div class="col-md-12 m-b-20"> >>>> <!-- <select class="form-control generic-widget" >>>> id="no_table_address_type" name="address_type"><option >>>> value="">Vazio</option><option value="1">Comercial</option><option >>>> value="2">Residencial</option></select> --> >>>> >>>> <select class="form-control selectpicker" >>>> id="no_table_address_type" name="address_type" data-style="btn-info >>>> btn-outline-info"> >>>> >>>> {{for t in address_type_list:}} >>>> <option value="{{=t.id}}">{{=t.type}}</option> >>>> {{pass}} >>>> </select> >>>> </div> >>>> <div class="col-md-12 m-b-20"> >>>> <select id="no_table_cities" name="cities" >>>> data-style="btn-info btn-outline-info" required> >>>> {{for city in cities_list:}} >>>> <option value="{{=city.id}}" >{{=city.name}}</option> >>>> {{pass}} >>>> </select> >>>> </div> >>>> >>>> <!--form.custom.end --> >>>> <div class="hidden"> >>>> {{=form.hidden_fields()}} >>>> </div> >>>> </div> >>>> >>>> <div class="modal-footer"> >>>> <input class="btn btn-info" type="submit" value="Salvar"> >>>> <button type="button" class="btn btn-default waves-effect" >>>> data-dismiss="modal">Cancelar</button> >>>> </div> >>>> </div> >>>> </form> >>>> >>>> >>>> >>>> >>>> now the problem: this selectpicker, simply my form can not store the >>>> value of select, when I add this class, I needed it, I do not need it that >>>> much, but it became a mission to understand what's happening here, I gave >>>> a >>>> print em form. vars.cities and she's just like None, help please >>>> >>>> <Storage {'name': 'maria', 'cpf': '09102910', 'birthday': None, >>>> 'email': 'rodg...@gmail.com', 'registration_date' public_place ':' ',' >>>> '' '' '' '' '' '' '' '' '' 'cities': None, 'address_type': None, 'person': >>>> 4}> >>>> >>> -- 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/d/optout.