See one answer down there...

On Wed, Sep 14, 2011 at 2:38 AM, annet <annet.verm...@gmail.com> wrote:
> In db.py I defined the following table:
>
> db.define_table('function',
>
> Field('bedrijf_id',db.bedrijf,default='',notnull=True,unique=True),
>    Field('home',type='boolean',default=True,writable=False),
>    Field('logo',type='boolean',default=False),
>    Field('tagline',type='boolean',default=False),
>    Field('image',type='boolean',default=False),
>    Field('text',type='boolean',default=False),
>    Field('css',type='boolean',default=False),
>    Field('customcss',type='boolean',default=False),
>    Field('keywords',type='boolean',default=False),
>    Field('notitie',type='text'),
>    Field('counter',type='integer',default=1),
>    migrate=False)
>
>
> In the following function the administrator makes functions (not)
> available by setting them to True or False.
>
> @auth.requires_membership('Admin')
> def functions():
>    ....
>    row=db(db.function.bedrijf_id==id).select().first()
>    form=crud.update(table=db.function,record=row)
>    ....
>    return dict(form=form)
>
> row.counter should be set based on the number of functions being True,
> is there a way to loop through a table's fields?


for field in db[table].fields:
   do something


>
> ... and how would I use:
>
> crud.settings.update_onaccept = StorageList()
>
> ... to implement a function that counts the number of fields being
> True and set row.counter
>
>
> Kind regards,
>
> Annet.


Richard

Reply via email to