myfields = [db.myable.fieldname1, db.mytable.fieldsname2] SQLTABLE(db(db.mytable.id>0).select(*myfields))
On Sep 11, 1:56 pm, tvw <[email protected]> wrote: > Hi, > I am displaying a database table as a table in a page using jQuery > dataTables - this is great but I also want to be able to select the > database fields which are shown. I've put checkboxes below the table > so that I will get returned a list of the fields I want to display. > The problem is I can't get the select to work on a list, i.e. > > SQLTABLE(db(db.mytable.id>0).select(myfields)) > > what form should myfields be in ? > > SQLTABLE(db(db.mytable.id>0).select(db.mytable.ALL)) > > works fine, but myfields = [fieldname1, fieldsname2, ...] doesn't > > can anyone help ? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
