Sorry my mistake, now i view your definition
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()))
'day' you have as an integer.
On Aug 9, 9:59 am, "Martin.Mulone" <[email protected]> wrote:
> because you define in db as time, and need to be datetime. I think
>
> On Aug 9, 9:51 am, Kenneth Lundström <[email protected]>
> wrote:
>
>
>
> > Now I�m getting:
>
> > Traceback(most recent call last):
> > File"gluon/restricted.py",line178,inrestricted
> > execccodeinenvironment
> >
> > File"/data/domains/exp-kal.nudata.fi/applications/init/controllers/troop.py
> > "
> > <https://exp-kal.nudata.fi/admin/default/edit/init/controllers/troop.py>,line2195,in<module>
> > File"gluon/globals.py",line96,in<lambda>
> > self._caller=lambdaf:f()
> > File"gluon/tools.py",line2219,inf
> > returnaction(*a, **b)
> >
> > File"/data/domains/exp-kal.nudata.fi/applications/init/controllers/troop.py
> > "
> > <https://exp-kal.nudata.fi/admin/default/edit/init/controllers/troop.py>,line985,inedit_saleplace
> > days=db((db.troop_place_day.day()
> > ==2)&(db.troop_place_day.troop_place==21)).select()
> > TypeError:'Field'objectis notcallable
>
> > But why should I use day(), is day a reserved word, should I use
> > something else instead.
>
> > Kenneth
>
> > > change with: db.troop_place_day.day()==2 if I not wrong
>
> > > On Aug 9, 8:31 am, Kenneth<[email protected]> 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
