[web2py] Re: Query not returning correct data

[Mihir Lade]

Hi Alan, 

I tried changing to == however now it won't return any data at all... 
Another way i was trying was.. 

def displayFlights():
    tuples=db((db.Flight.DepartureLocation is 
request.vars.DepartureLocation)&
       (db.Flight.ArrivalLocation is request.vars.ArrivalLocation)&
       (db.Flight.DepartureDate is request.vars.DepartureDate)&
       (db.Flight.ArrivalDate is 
request.vars.DepartureDate)).select(db.Flight.ALL)
    return dict(tuples=tuples)

but that does the same thing where it just displays all the flights in the 
table and not the ones preferred by the user.. 
any other suggestions?

--