Re: [web2py] Re: sql between function

2010-02-28 Thread Stelios Koroneos
On Sat, 2010-02-27 at 19:13 -0800, mr.freeze wrote: > def datesearch(): > matches=None > form = > SQLFORM.factory(Field('start_date','date',requires=IS_NOT_EMPTY()), > > Field('end_date','date',requires=IS_NOT_EMPTY())) > if form.accepts(request.vars,session): > (sy,sm,sd) = (

[web2py] Re: sql between function

2010-02-27 Thread mr.freeze
def datesearch(): matches=None form = SQLFORM.factory(Field('start_date','date',requires=IS_NOT_EMPTY()), Field('end_date','date',requires=IS_NOT_EMPTY())) if form.accepts(request.vars,session): (sy,sm,sd) = (int(x) for x in form.vars.start_date.split('-')) (ey,em,ed)