I used jqGrid with webpy, it is easy to implement. When you build jqGrid (in js) you ll define rows and pages info and when pagination links clicked jqGrid sends "row" and "post" data to your post method (which you defined). After that you just build sql something like "select first row skip page*row columns from table" and than return data. I suggest to send data as json object.
2010/7/15 ProfessionalIT <[email protected]> > Hi Friends, > > I'm developing a page with a list of records in a "html-table". In > this "html-table" I need some features: search on this list, > pagination the records and sort of columns. > > Searching in the web I found two very interesting solutions: JQGrid > (http://www.trirand.com/blog/) and JQuery Datatable (http:// > www.datatables.net). > > These two solutions are excellent and very easy to configure / > deploy when the pagination and the search is performed only at the > client-side of your app, in this case, all records are loaded in the > html-table in the first access of page, then these frameworks make all > the paging, sorting and searching in the client-side (but all records > are in this rendered page). > > This behavior have a problem: the time spent to load the page when > the list has many records. I have a app made with Web2Py deployed in > AppEngine where when I access the 'Customers List Page'(that have 400 > records) I wait 2 or 3 minutes to complete the 'load' of this page. > > As developer, in the first moment you think: "Well, let's go > implement the pagination, sorting and searching in the 'server-side' > and in the docs page of this two solutions you have same samples with > the 'server-side processing' but this samples are in PHP and I don't > know PHP. > > If anyone has a solution(or similiar solution) for this type of > problem and would like to help I would be extremely grateful. > > I have developed a solution (that have same (many) bugs) without this > frameworks: http://professionalitsge.appspot.com/formas_pagamento > (need a google account to access) > > This project is a small ERP made with web.py and running in GAE - > Google App Engine and in a next moment I'll share the code. > > any idea or suggestion ? > > Thanks for all help. > > best regards, > Leandro. > > -- > You received this message because you are subscribed to the Google Groups > "web.py" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected] <webpy%[email protected]>. > For more options, visit this group at > http://groups.google.com/group/webpy?hl=en. > > -- Aydın Şen -- You received this message because you are subscribed to the Google Groups "web.py" 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/webpy?hl=en.
