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

Reply via email to