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
-~----------~----~----~----~------~----~------~--~---

Reply via email to