I would suggest you do instead
items=db(db.task.taskarea=='Hardware').select(db.task.ALL)
return dict(items=items)
You can then access items[i].startTime etc and do what you need.
On Apr 13, 6:02 pm, Wes James <[email protected]> wrote:
> This works:
>
> def item_tasks():
> return crud.select(db.task, db.task.taskarea=='Hardware') or "No data"
>
> but I have a startTime and endTime in the DB and would like to have
>
> query="sum(endTime - startTime) in the crud.select. Where do you put
> the sum in with crud formatting?
>
> thx,
>
> -wj
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
