yes
db(db.table.field0=='somevalue').select (db.table.field1,db.table.field2,orderby=db.table.field3) On Jul 18, 7:58 pm, ionel <ionelanton...@gmail.com> wrote: > Just to be more clear. The user can select multiples fields, from one > to all. > > On Jul 18, 8:55 pm, ionel <ionelanton...@gmail.com> wrote: > > > Hello everyone, > > > I have a table with multiples fields (20). The user can select the > > fields for searching the table. He can select one field or all the > > fields in any combination. I need to create a query with his > > selection. Is this thing possible in web2py but without using > > executesql() ? > > > Thanks. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---