Hello,
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)))
I have a DB called ToolsDB and I have several tables in that. Each table
has an field called 'serial_number'. I want to pass a SELECT to the html
with the tools in the selected table.
> For example, if I have two rows in my table, say, tool_1 and tool_2, the
> resulting drop down will have only one entry which says *
> TABLE1.serial_numbertool_1tool_2*. Both tools are in the same row. I
> can't understand why the two tools are shown in one entry in the drop down
> select. So a SELECT drop down is actually passed but the entries are not
> passed correctly.
However when I do:
def showToolEntries():
if request.args(0) inToolsDB.tables:
return dict(entries=,ToolsDB().select(operationalToolsDB[request.
args(0)].serial_number))
I can properly see the tool entries correctly printed out as:
> TABLE1.serial_number
> tool_1
> tool_2
Could somebody please help me with this.
Thank you.
Cheers.
