Sorry, didn't read close enough.
On Sep 11, 2:03 pm, mdipierro <[email protected]> wrote:
> 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 ?- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
