Last night I couldn't figure out to use SQLTABLE's columns param when ROWS
I'm trying to display are from an inner join. The ROW objects are composed
of dict-like objects for both [or more] tables, i.e.,
{{segment={id=1234567890, waypoint="Thishereplace",route="thataway", partof=
666}},
{run={id=666,description="InAHandbasket"}}
(my apologies if some of those brackets should be square instead of curly;
I forgot to cuttenpaiste last night when the examples were dancing before
my eyes)
In the columns param, [db.run.id, ...] didn't work, and [run[].id, ...]
didn't work, and I don't think [myrows.run.id, ...] worked (where myrows is
the query result). And query results don't name the ROW structure inside
the ROWS. So what would work?
BTW, I did find a way around this problem ... make the select() do just the
fields needed for the display, which I understand to be the way
SQLFORM.grid works. Oh, and I probably could use this project as a way to
learn to use datatables or a similar js library. But is there an answer to
my original approach?
T'anks
/dps
--
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.
