you can do: db.table.field.between = lambda a,b: (db.table.field>a)&(db.table.field<=b)
db(db.table.field.between(a,b)).select() perhaps we should define it in dal.py. On Saturday, 3 August 2013 03:20:31 UTC-5, Jayakumar Bellie wrote: > > Ya your correct, this is supported. I have tried it. > But wanted to check if between is supported. > > On Saturday, August 3, 2013 11:35:16 AM UTC+5:30, Annet wrote: >> >> I don't think web2py supports 'between'. However, this works: >> >> (db.table.startDatetime>datetime1)&(db.table.endDatetime<datetime2) >> >> >> Kind regards, >> >> Annet >> > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
