On Thursday, January 28, 2016 at 8:36:47 AM UTC-8, Lucas Schreiber wrote:
>
> Hi,
> ist there a way to change the column of the record in an SQLFORM?
>
> For example, my code looks like this:
>
> module
> dba.define_table('test_table',
> Field('field_1', 'integer'),
> Field('field_2', 'integer'))
>
> controller
>
> def index():
>
> record = 1
>
> form=SQLFORM(dba.test_table, record, submit_button='test')
>
> return dict (b=form)
>
>
>
> When i understand it correctly, the record matches the autocreated id Field
> of the table, is there a way to match it with the field_1, for example?
>
>
>
Wouldn't that just be a db query? Your example always uses '1' for the
record, which I think leves out a step, but the examples in the book all
use
record = db.test_table(1) # or, more often, request.args(0)
to select a record, and doing
record = db(db.test_table.field_1 == request.args(0)).select()
would get the record(s) where field_1 matches the input.
/dps
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
