See also Jonathon's response in the parallel thread: <URL:https://groups.google.com/d/msg/web2py/HCDEdn6Me6o/W6IfXfpMpOAJ>
/dps On Thursday, August 20, 2015 at 12:51:20 PM UTC-7, Dave S wrote: > > > > On Thursday, August 20, 2015 at 3:28:47 AM UTC-7, Iancic Bogdan wrote: >> >> I have a lot of entries in the table that I want to display, and as i >> already have other things on the same page, i want to make this table show >> only 10-20 entries per page. How can I add that? >> >> > Essentially, you're going to use "limitby" in the query, and then when the > user wants to look at more data, use a trigger (for instance, a "more" > button) to reload the page with the new data, or use an ajax function to do > a partial load. > > <URL: > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#orderby--groupby--limitby--distinct--having-orderby_on_limitby-left-cache > > > <URL: > http://web2py.com/books/default/chapter/29/11/jquery-and-ajax#Ajax-form-submission > > > > Note that the application's appadmin page uses "limitby", and does a page > reload with the URL updated to > "//myserver/myapp/appadmin/select/db?start=100". > > Good luck! > > /dps > > > >> Here is the code I wrote in view: >> >> {{if prints:}} >> <h3>{{=T('Print history:')}}</h3> >> {{i=0}} >> <table> >> <thead> >> <th>#</th> >> <th>{{=T('Component name')}}</th> >> <th>{{=T('Component code')}}</th> >> <th>{{=T('Number of components')}}</th> >> <th>{{=T('Printing date')}}</th> >> </thead> >> <tbody> >> {{for design in prints:}} >> <tr><td>{{=i+1}}</td><td> >> {{=design.fk_printhistory_componentcatalog.component_name}}</td><td>{{=design.fk_printhistory_componentcatalog.component_code}}</td><td>{{=design.no_of_components}}</td><td>{{=design.time_stamp}}</td></tr> >> {{i=i+1}} >> {{pass}} >> </tbody> >> </table> >> {{pass}} >> > -- 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.
