qset is just a variable. You can call it "a" if you like. the idea is that
a=db defines a set of all records of all table b=a(query1) defined a subset as limited by the query c=b(query2) defined a subset of the previous subset etc etc then you can do rows = c.select() to get all records in the set. On Oct 20, 7:46 pm, Sebastian Brandt <snoogi...@gmail.com> wrote: > One more question: > What does qset actually do? > > 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 -~----------~----~----~----~------~----~------~--~---
