What you say let me think that you could be interrested by Datatables grid view javascript plugins... Bruno Rocha has make a web2py Plugin : PowerTable with it you can have 2 tables embeded into the same grid if I remember. So you can display resume row and when expend row you have the other table contain. It is maybe something you would have...
http://powertable.blouweb.com/products Try to clic the + button for a given row you will understand better. Richard On Wed, Feb 15, 2012 at 1:35 PM, Bruce Wade <[email protected]> wrote: > My correction also, I am redesigning the page to *NOT* use a SQLFORM.grid > :D > > The data is for each month of the year so going to change the design to > show the months, and when clicking on a month get more details. > > On Wed, Feb 15, 2012 at 9:59 AM, Richard Vézina < > [email protected]> wrote: > >> Correction columns not rows... >> >> Richard >> >> On Wed, Feb 15, 2012 at 12:58 PM, Richard Vézina < >> [email protected]> wrote: >> >>> For sure SQLFROM.grid is the way to go, but for me CRUD let me do much >>> more thing that I can't handle with SQLFORM.grid perhap I just don't find a >>> way to make it works with it. >>> >>> You can always use SQLTABLE with which you can display any kind of raw >>> SQL query result or web2py query... You can also use helpers ans build your >>> own SQLFORM.grid acces CRUD functions. I mean, use represent over multiple >>> id *columns* that display a link build on the fly with helpers. >>> >>> Richard >>> >>> >>> On Wed, Feb 15, 2012 at 12:14 PM, Bruce Wade <[email protected]>wrote: >>> >>>> Ok for my currently situation I am redesigning the page to now use a >>>> SQLFORM.grid but have looked at the source and it shouldn't be overly >>>> complicated to add a query string option so I will look into that more once >>>> I launch my site in 3 weeks. >>>> >>>> >>>> On Tue, Feb 14, 2012 at 10:48 PM, Johann Spies >>>> <[email protected]>wrote: >>>> >>>>> On 15 February 2012 03:23, Bruce Wade <[email protected]> wrote: >>>>> >>>>>> >>>>>> It would be nice if SQLFORM.grid() would except more advanced query's >>>>>> I am going to read through the code for it to see if their is any way to >>>>>> extend it. Or even if we can just feed it the data and it just displays >>>>>> what you send it. >>>>>> >>>>>> >>>>> +1 >>>>> >>>>> Johann >>>>> -- >>>>> Because experiencing your loyal love is better than life itself, >>>>> my lips will praise you. (Psalm 63:3) >>>>> >>>>> >>>> >>>> >>>> -- >>>> -- >>>> Regards, >>>> Bruce Wade >>>> http://ca.linkedin.com/in/brucelwade >>>> http://www.wadecybertech.com >>>> http://www.warplydesigned.com >>>> http://www.fitnessfriendsfinder.com >>>> >>> >>> >> > > > -- > -- > Regards, > Bruce Wade > http://ca.linkedin.com/in/brucelwade > http://www.wadecybertech.com > http://www.warplydesigned.com > http://www.fitnessfriendsfinder.com >
