[web2py] Re: Query not returning correct data

[Mihir Lade]

Hi Anthony,
 
I am currently working with this code:
 
def displayFlights():
    query1 = SQLTABLE(db().select(db.Flight.DepartureDate == 
request.vars.DepartureDate))
    query2 = SQLTABLE(db().select(db.Flight.ArrivalLocation == 
request.vars.ArrivalLocation))
    query3 = SQLTABLE(db().select(db.Flight.DepartureDate == 
request.vars.DepartureDate))
    query4 = SQLTABLE(db().select(db.Flight.ArrivalDate == 
request.vars.ArrivalDate))
   
    rows = db(query1 & query2).select(db.Flight.ALL)
    return dict(rows=rows)
The error I am currently getting with this code is:

Error traceback  

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.

Traceback (most recent call last):
  File "I:\wdd-softw\web2py\gluon\restricted.py", line 184, in restricted
    exec ccode in environment
  File *"I:/wdd-softw/web2py/applications/Assignment/controllers/default.py"* 
<http://127.0.0.1:8000/admin/default/edit/Assignment/controllers/default.py>, 
line 115, in <module>
  File "I:\wdd-softw\web2py\gluon\globals.py", line 103, in <lambda>
    self._caller = lambda f: f()
  File *"I:/wdd-softw/web2py/applications/Assignment/controllers/default.py"* 
<http://127.0.0.1:8000/admin/default/edit/Assignment/controllers/default.py>, 
line 107, in displayFlights
    query1 = SQLTABLE(db().select(db.Flight.DepartureDate == 
request.vars.DepartureDate))
  File "I:\wdd-softw\web2py\gluon\sql.py", line 2913, in select
    return self.parse(db,rows,self.colnames)
  File "I:\wdd-softw\web2py\gluon\sql.py", line 2932, in parse
    field = table[fieldname]
  File "I:\wdd-softw\web2py\gluon\sql.py", line 1481, in __getitem__
    return dict.__getitem__(self, str(key))
KeyError: "DepartureDate='01/19/2013'"



--