[web2py] Re: Passing a SELECT

2012-05-20 Thread Madu
Thank you very much Anthony for your detailed explanation. I didn't realize the db select returns a Rows object. Your solution worked! Thank you. On Sunday, May 20, 2012 11:03:33 PM UTC+9, Anthony wrote: > > I'm trying to pass a SELECT as follows: >> def showToolEntries(): >> if request.ar

[web2py] Re: Passing a SELECT

2012-05-20 Thread Anthony
> > I'm trying to pass a SELECT as follows: > def showToolEntries(): > if request.args(0) in ToolsDB.tables: > return dict(entries=SELECT("Select from list", operationalToolsDB > ().select(ToolsDB[request.args(0)].serial_number))) > SELECT() takes either a list or a set of positional