web2py,TypeError: an integer is required

Question

I am using the follow to highlight a date field where the date is greater then the current date.

    db.stock_task.ESI_withhold_until_date.represent=lambda v,
    row:SPAN(datetime.date(v),_class='withhold' if v and v> 
    datetime.date.today()else None)

    db.stock_task.withhold_until_date.represent = lambda v, row:
    SPAN(prettydate(v),_class='withhold' if v and v>datetime.date.today()
    else None)

Error log:

Traceback (most recent call last):
        File "/home/tony/web2py/gluon/restricted.py", line 227, in restricted
        exec ccode in environment
        File "/home/tony/web2py/applications/cps5c/controllers/default.py", 
        line 562, in <module>
        File "applications/cps5c/modules/plugin_sqleditable/editable.py", 
        line 415, in extract
        r=func()
        File "/home/tony/web2py/gluon/tools.py", line 3774, in f
        return action(*a, **b)
        File "/home/tony/web2py/applications/cps5c/controllers/default.py", l
        ine 268, in stock_tasks
        db.stock_task.created_by,
        File "/home/tony/web2py/gluon/sqlhtml.py", line 2717, in grid
        nvalue = field.represent(value, row)
         File "/home/tony/web2py/applications/cps5c/models/db1.py", 
         line 144, in <lambda>

        db.stock_task.ESI_withhold_until_date.represent = lambda v,
        row: SPAN(datetime.date (v),_class='withhold' if v > 
        datetime.date.today()else None)

TypeError: an integer is required

if I use the following it works fine.

    db.stock_task.withhold_until_date.represent = lambda v, row:
    SPAN(prettydate(v),_class='withhold' if v and v>datetime.date.today()
    else None)

any help appreciated

cheers

I think that the 'else None' you are using may crash it, try returning 0 instead for example. — Netwave, Nov 11 '15 at 09:31
Same result, I think it is somtething in the controller but cant work out what — user3502263, Nov 11 '15 at 09:36
db.stock_task.ESI_withhold_until_date.represent = lambda v, row: SPAN(v,_class='withhold' if v > datetime.date.today()else None) — user3502263, Nov 11 '15 at 19:03

score 0 · Answer 1 · edited Nov 11 '15 at 19:08

0

db.stock_task.ESI_withhold_until_date.represent = lambda v, row: SPAN(v,_class='withhold' if v > datetime.date.today()else None)

edited Nov 11 '15 at 19:08

Celeo

5,583
8
39
41

answered Nov 11 '15 at 19:06

user3502263

11
5

web2py,TypeError: an integer is required

1 Answers1