DataTables has an API that allows retrieving data from almost any data source (DOM, Javascript array, Ajax file and server-side processing (web2py, PHP, C#, Perl, Ruby, AIR, Gears etc) so you don't have to push all of your data to the client at once (you are right, this would not be wise for large tables). You can read about it here: http://datatables.net/api
On Aug 26, 11:12 pm, Iceberg <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
