change with: db.troop_place_day.day()==2 if I not wrong
On Aug 9, 8:31 am, Kenneth <kenneth.t.lundst...@gmail.com> wrote: > I don´t understand what am I doing wrong. > > command: > days = db((db.troop_place_day.day == > 2)&(db.troop_place_day.troop_place == 21)).select() > > gives this error: > > Traceback (most recent call last): > File "gluon/restricted.py", line 178, in restricted > exec ccode in environment > File "/data/domains/exp-kal.nudata.fi/applications/init/controllers/ > troop.py", line 2195, in <module> > File "gluon/globals.py", line 96, in <lambda> > self._caller = lambda f: f() > File "gluon/tools.py", line 2219, in f > return action(*a, **b) > File "/data/domains/exp-kal.nudata.fi/applications/init/controllers/ > troop.py", line 985, in edit_saleplace > days = db((db.troop_place_day.day == > 2)&(db.troop_place_day.troop_place == 21)).select() > File "gluon/sql.py", line 3162, in select > return self.parse(db,rows,self.colnames,SetClass=Set) > File "gluon/sql.py", line 3231, in parse > str(value)[:8].strip().split(':')[:3]] > ValueError: invalid literal for int() with base 10: '1 day, 0' > > My model for that table looks like this: > > db.define_table('troop_place_day', > db.Field('troop_place', db.troop_place, required=True), > db.Field('day', 'integer'), > db.Field('starts', 'time', requires=IS_TIME()), > db.Field('ends', 'time', requires=IS_TIME())) > > This error just started coming maybe an hour ago. I just deleted all > records from the record and same thing continues. > > I really don't understand what is happening. > > Kenneth