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?
