ok, it worked and after one browser refresh it stoped working. How could I show you that it worked somehow??
On Jun 16, 1:18 pm, greenpoise <[email protected]> wrote: > Oops my bad. This one > > desde=datetime.datetime(request.now.year,request.now.month,request.now.day) > hasta=desde+datetime.timedelta(days=10) > > form=FORM (H1(TABLE > (TR(('From:',INPUT(_name="desde",_class='date',_value=desde,_id="desde",requires=IS_DATE())), > > ('To:',INPUT(_name="hasta",_class='date',_id="hasta",_value=hasta,requires=IS_DATE()))), > INPUT(_type='submit')))) > > rows = db((db.orden.fechaorden >= > request.vars.desde)&(db.orden.fechaorden <= > request.vars.hasta)).select(db.orden.waitertip.sum()) > for row in rows: print > row[db.orden.waitertip.sum()] > > return dict(form=form,rows=rows) > > On Jun 16, 1:09 pm, greenpoise <[email protected]> wrote: > > > I dont know how this could be different but this one did worked: > > > desde=request.now > > hasta=request.now > > > desde=datetime.datetime(request.now.year,request.now.month,request.now.day) > > hasta=desde+datetime.timedelta(days=10) > > > form=FORM (H1(TABLE > > (TR(('From:',INPUT(_name="desde",_class='date',_value=desde,_id="desde",requires=IS_DATE())), > > > ('To:',INPUT(_name="hasta",_class='date',_id="hasta",_value=hasta,requires=IS_DATE()))), > > INPUT(_type='submit')))) > > > rows = db((db.orden.fechaorden >= > > request.vars.desde)&(db.orden.fechaorden <= > > request.vars.hasta)).select(db.orden.waitertip.sum()) > > for row in rows: print > > row[db.orden.waitertip.sum()] > > > return dict(form=form,rows=rows) > > > I do however get some receding zeros after the date in my date field > > of the form. > > > On Jun 15, 11:51 pm, mdipierro <[email protected]> wrote: > > > > This should never have worked. > > > > On Jun 15, 8:57 pm, "mr.freeze" <[email protected]> wrote: > > > > > I would just check that fromvar and tovar are not None before getting > > > > the rows. > > > > > On Jun 15, 8:40 pm, greenpoise <[email protected]> wrote: > > > > > > here it is: > > > > > > Error traceback > > > > > > 1. > > > > > 2. > > > > > 3. > > > > > 4. > > > > > 5. > > > > > 6. > > > > > 7. > > > > > 8. > > > > > 9. > > > > > 10. > > > > > 11. > > > > > 12. > > > > > 13. > > > > > 14. > > > > > 15. > > > > > 16. > > > > > > Traceback (most recent call last): > > > > > File "/home/danel/Applications/web2py/gluon/restricted.py", line > > > > > 178, in restricted > > > > > exec ccode in environment > > > > > File "/home/danel/Applications/web2py/applications/shroomV2/ > > > > > controllers/default.py", line 314, in <module> > > > > > File "/home/danel/Applications/web2py/gluon/globals.py", line 96, in > > > > > <lambda> > > > > > self._caller = lambda f: f() > > > > > File "/home/danel/Applications/web2py/gluon/tools.py", line 2036, in > > > > > f > > > > > return action(*a, **b) > > > > > File "/home/danel/Applications/web2py/applications/shroomV2/ > > > > > controllers/default.py", line 245, in qryfecha > > > > > rows = db((db.orden.fechaorden >= fromvar)&(db.orden.fechaorden <= > > > > > tovar)).select(db.orden.waitertip.sum()) > > > > > File "/home/danel/Applications/web2py/gluon/sql.py", line 2483, in > > > > > __ge__ > > > > > return Query(self, '>=', value) > > > > > File "/home/danel/Applications/web2py/gluon/sql.py", line 2866, in > > > > > __init__ > > > > > raise SyntaxError, 'Operation %s can\'t be used with None' % op > > > > > SyntaxError: Operation >= can't be used with None > > > > > > On Jun 15, 9:37 pm, "mr.freeze" <[email protected]> wrote: > > > > > > > Do you get an error? If so, can you show the traceback? > > > > > > > On Jun 15, 8:01 pm, greenpoise <[email protected]> wrote: > > > > > > > > Ok this used to work: > > > > > > > > def qryfecha(): > > > > > > > > form=FORM (H1(TABLE > > > > > > > (TR(('From:',INPUT(_name="desde",_class='date',_id="desde",requires=IS_DATE > > > > > > > ())), > > > > > > > > ('To:',INPUT(_name="to",_class='date',_id="to",default=request.now,requires > > > > > > > =IS_DATE())))), > > > > > > > INPUT(_type='submit'))) > > > > > > > > fromvar=request.vars.desde > > > > > > > tovar=request.vars.to > > > > > > > > rows = db((db.orden.fechaorden >= > > > > > > > fromvar)&(db.orden.fechaorden <= > > > > > > > tovar)).select(db.orden.waitertip.sum()) > > > > > > > for row in rows: print > > > > > > > row[db.orden.waitertip.sum()] > > > > > > > > return dict(form=form,rows=rows) > > > > > > > > not anymore. Leads?
