rows=db(query).select()
table=SQLTABLE(rows,columns=['table.fieldname1',table.fieldname2'],headers=='fieldname:capitalize')
and
{{=table}}
On Apr 25, 12:29 pm, dave <[email protected]> wrote:
> I have a need to let the user pick up to 4 optional sets of columns (a
> required set will always be included) to be included when a query is
> run. This means 16 different combination of columns. Instead of having
> to specify 16 different statements like rows=db.select(sql).
> (col1,col2,...,coly,colz) statements, I want to build the set of
> columns to be retrieved first and then have just 1 statement like
> rows=db.select(sql)(???). But what is the ??? syntax?
> Thanks, Dave
>
> --
> Subscription settings:http://groups.google.com/group/web2py/subscribe?hl=en
