Re: [web2py] Populating widgets with queries

2012-09-08 Thread Mike Girard
The IS_IN_DB etc didn't work for me -- perhaps I did something wrong -- but the variations with IS_IN_SET do. Thanks! On Saturday, September 8, 2012 2:46:24 AM UTC-4, rochacbruno wrote: > > maybe this? > > form = SQLFORM.factory( > Field('test', > type='string', > require

Re: [web2py] Populating widgets with queries

2012-09-07 Thread Bruno Rocha
maybe this? form = SQLFORM.factory( Field('test', type='string', requires=IS_IN_DB(*db(db.table.field == xyz)*, db.city.name_url, '%(name)s', multiple=True), widget=lambda f, v: SQLFORM.widgets.checkboxes.widget(f, v, style='divs'), default = 'New-York'), fo

[web2py] Populating widgets with queries

2012-09-07 Thread Mike Girard
I have a checkboxes widget which I invoke like so: form = SQLFORM.factory( Field('test', type='string', requires=IS_IN_DB(db, db.city.name_url, '%(name)s', multiple=True), widget=lambda f, v: SQLFORM.widgets.checkboxes.widget(f, v, style='divs'), default