I am impressed Massimo :-) It actually works, thank you very much. Greetings Sebastian Brandt
On 21 Okt., 02:24, mdipierro <mdipie...@cs.depaul.edu> wrote: > I am not sure I understand but I am going to make a guess > > qset=db(db.events.severity==request.vars.severity)\ > (db.events.status==request.vars.status)\ > (db.events.status==db.status.id)\ > (db.events.severity==db.severity.id) > if request.vars.message: > qset=qset(db.events.message==request.vars.message) > if request.vars.host: > qset=qset(db.events.host==request.vars.host) > rows=qset.select(orderby=~db.events.datetime_submitted) > > On Oct 20, 6:28 pm, Sebastian Brandt <snoogi...@gmail.com> wrote: > > > Hi everyone, > > > I am trying to create a dynamic SQL Query. > > I have a form where a user can input several fields. I want to perfom > > a query whether a user has filled out all fields or not. > > > Got the following code: > > > if not request.vars.message: > > request.vars.message='' > > if not request.vars.host: > > request.vars.host='' > > rows=db(db.events.host==request.vars.host) > > (db.events.message==request.vars.message) > > (db.events.severity==request.vars.severity) > > (db.events.status==request.vars.status)(db.events.status==db.status.id) > > (db.events.severity==db.severity.id).select > > (orderby=~db.events.datetime_submitted) > > form=SQLFORM(db.events) > > return dict(form=form,rows=rows) > > > If message and/or host are empty I get an empty query. Can I avoid > > this anyhow or do I have to code a huge if-else-thingy to get my > > result? :-) > > > Greetings > > > Sebastian Brandt --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
