I just tested with {{= form}} and it really worked, so the problem is
between
<form action="#" class="form-material" enctype="multipart/form-data" method=
"post">
<input...
<input...
<input...
<input...
<div class="hidden"> {{=form.hidden_fields()}}
</div>
<input class="btn btn-info" type="submit" value="Salvar">
</form>
terça-feira, 21 de Agosto de 2018 às 13:46:55 UTC-3, Jim S escreveu:
>
> 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.
