Are you sure there are records coming back? Try doing a "print
records" and make sure data is coming back. Sounds like it just may
be an empty result set from the query.
On Nov 9, 6:50 pm, Lorin Rivers <lriv...@mosasaur.com> wrote:
> 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:lriv...@mosasaur.com>
> 512/203.3198 (m)
