Sorry for chime in. DataTable looks definitely cool, but I havn't tried it yet. I still wonder what is the best practice if the table content is too large (say, hundreds even thousands of records) to be transmitted on client side. Do we need to serve only part of them to the client-side DataTable? If so, how could a user know he is just looking at "page #n of part #m" of the entire set? How to arrange the UI for that?
On Aug27, 5:27am, "mr.freeze" <[email protected]> wrote: > I think you will need something like this: > > <table id="sortpage"> > <thead> > <tr> > <th>Title</th> > etc... > </tr> > </thead> > <tbody> > {{for r in results:}} > <tr> > <td>{{=r.title}}</td> > etc... > </tr> > {{pass}} > </tbody> > </table> > <div id="pager"></div> > > Then at the end of web2py_ajax_init javascript function of > web2py_ajax.html: > jQuery("#sortpage").dataTable(); > > Hope that helps. > > On Aug 26, 12:27 pm, FERNANDO VILLARROEL <[email protected]> > wrote: > > > > > Dear All. > > > I am trying of doing a query for get some records from a database and show > > results on a Data Tables (Jquery), i am new in Web development (Ajax and > > Jquery, Json, etc.) and i want know how doing. > > > The idea is get all records that fecha >= to var "desde" and show in a Data > > Tables --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" 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 -~----------~----~----~----~------~----~------~--~---
