SQLTABLE(db(db.mytable.id>0).select (db.mytable.myfield1,db.mytable.myfield2, etc...))
On Sep 11, 1:56 pm, tvw <surftas...@gmail.com> 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 web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
