I think I'm close:
given this controller
my_macaddr = db4().select(db4.data_table.MacAddr, distinct=True)
def display_form():
form = FORM(TR("Select a MAC Address :",
SELECT(_name='MacAddrSelect',
*[OPTION(my_macaddr[i].MacAddr, _value=str(my_macaddr[i].MacAddr)) for i in
range(len(my_macaddr))])),
TR(INPUT(_type='submit')))
records = db4((db4.data_table.MacAddr==form.vars.MacAddrSelect) &
(db4.data_table.ReqTime>='2010-11-08T21:00')
&
(db4.data_table.ReqTime<='2010-11-08T22:00')).select(db4.data_table.MacAddr,db4.data_table.ReqTime,db4.data_table.Po)
return
dict(form=form,records=SQLTABLE(records),vars=form.vars,vars2=request.vars)
and this in my view:
{{extend 'layout.html'}}
<h2>Input form</h2>
{{=form}}
<h2>Results</h2>
<p>{{=records}}</p>
<h2>Submitted variables</h2>
{{=BEAUTIFY(request.vars)}}
<h2>Accepted variables</h2>
{{=BEAUTIFY(form.vars)}}
<h2>Errors in form</h2>
{{=BEAUTIFY(form.errors)}}
My form is displaying the request.vars and the three elements in the select(),
but no results.
What am I missing/doing wrong?
--
Lorin Rivers
Mosasaur: Killer Technical Marketing <http://www.mosasaur.com>
<mailto:[email protected]>
512/203.3198 (m)
