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 <[email protected]> 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:[email protected]>
> 512/203.3198 (m)
