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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.