Re: [web2py] Re: Not getting a result from query

[Lorin Rivers]

Alex,

You put me on the right track! Thanks.

-- 
Lorin Rivers
Mosasaur: Killer Technical Marketing 

512/203.3198 (m)

[web2py] Re: Not getting a result from query

[Alex]

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  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'}}
> Input form
> {{=form}}
> Results
> {{=records}}
> Submitted variables
> {{=BEAUTIFY(request.vars)}}
> Accepted variables
> {{=BEAUTIFY(form.vars)}}
> Errors in form
> {{=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 
> 
> 512/203.3198 (m)