options=[str(my_macaddr[i].MacAddr) for i in range(len(my_macaddr))] form=SQLFORM.factory(Field('macs',requires=IS_IN_SET(options,multiple='multiple'))) if form.accepts(request): dbset=db4((db4.data_table.ReqTime>='2010-11-08T21:00')&(db4.data_table.ReqTime<='2010-11-08T22:00'))
if form.vars.macs: query = reduce(lambda a,b:a|b,[db4.data_table.MacAddr==x for x in form.vars.macs]) dbset=dbset(query) records = dbset.select(db4.data_table.MacAddr,db4.data_table.ReqTime,db4.data_table.Po) else: records=[] On Nov 12, 1:43 pm, Lorin Rivers <lriv...@mosasaur.com> wrote: > Massimo, > > Thanks, that works great! > > What do I do to get it to only run on submit instead of load? > > BTW, one of the things that's most awesome about web2py is your activity on > the list and how helpful you are. I for one really appreciate that! > > On Nov 12, 2010, at 10:12 , mdipierro wrote: > > > options=[str(my_macaddr[i].MacAddr) for i in range(len(my_macaddr))] > > > form=SQLFORM.factory(Field('macs',requires=IS_IN_SET(options,multiple='multiple'))) > > > dbset=db4((db4.data_table.ReqTime>='2010-11-08T21:00')&(db4.data_table.ReqTime<='2010-11-08T22:00')) > > if form.accepts(request) and form.vars.macs: > > query = reduce(lambda a,b:a|b,[db4.data_table.MacAddr==x for x in > > form.vars.macs]) > > dbset=dbset(query) > > records = > > dbset.select(db4.data_table.MacAddr,db4.data_table.ReqTime,db4.data_table.Po) > > -- > Lorin Rivers > Mosasaur: Killer Technical Marketing <http://www.mosasaur.com> > <mailto:lriv...@mosasaur.com> > 512/203.3198 (m)