Re: [web2py] Re: DAL min on 2 date columns

2015-07-08 Thread Manuele Pesenti
Il 07/07/15 21:15, Dave S ha scritto: > > > On Tuesday, July 7, 2015 at 8:15:08 AM UTC-7, pjryan126 wrote: > > Why not make it Field('date_updated', 'datetime', > default=request.now, update=request.now) and then search on > date_updated only? > > > Jumping in, let me say that I like th

[web2py] Re: DAL min on 2 date columns

2015-07-08 Thread lyn2py
I have a database of data, which will periodically update the older entries or newly inserted entries, depending on how old the entry is, or if it was a newly created entry. For instance, the availability of a website. Someone adds a new website, date created is request.now I schedule a worke

[web2py] Re: DAL min on 2 date columns

2015-07-07 Thread 黄祥
not sure i fully understand what you want to achieve, but i guess you can use logical operator for that and combine it with DAL min. ref: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Logical-operators best regards, stifan -- Resources: - http://web2py.com - http:

[web2py] Re: DAL min on 2 date columns

2015-07-07 Thread Dave S
On Tuesday, July 7, 2015 at 8:15:08 AM UTC-7, pjryan126 wrote: > > Why not make it Field('date_updated', 'datetime', default=request.now, > update=request.now) and then search on date_updated only? > Jumping in, let me say that I like this. For rows that haven't been updated since they were c

[web2py] Re: DAL min on 2 date columns

2015-07-07 Thread pjryan126
Why not make it Field('date_updated', 'datetime', default=request.now, update=request.now) and then search on date_updated only? On Tuesday, July 7, 2015 at 9:04:21 AM UTC-4, lyn2py wrote: > > Hi, > > If I have 2 columns, date_created, date_updated > > db.define_table('table', > Field('date_