I need some help with a DAL query. I'm trying to update records, but my
query contains joins.
*tournament Table*
| id | start | end |
*match Table*
| id | tournamentID | home_team | away_team | start | end |
db( ((db.tournament.start >= '2015-01-01 00:00:00') & (db.tournament.end <=
'2015-12-31 00:00:00')) &\
(db.tournament.id == db.match.tournamentID) ).update(start=
db.match.start + timedelta(hours=1), end= db.match.end + timedelta(hours=1))
I want to add 1 hour to the start and end fields *in the match table* (not
the tournament table). But when I try to run this DAL statement, I get an
error saying "Too many tables" (because of the join, I suppose). What would
be an alternate single query for this?
Thanks
Note: Start and End columns are datetime.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
