Here is an example of Ingrid doing what you are looking for. http://sutternow.com/sti/summaryIngrid.action
tablesorter does not have the ajax/pagination bits. Your pretty much rolling your own. On May 7, 1:25 am, Adwin Wijaya <[EMAIL PROTECTED]> wrote: > Uhmm ... flexigrid looks more difficult to master that tablesorter :) > > btw, can tablesorter sort using ajax and pagination. I have 1000 data > and I dont want to throw all the data to user. so i use pagination, > separated into 10 records per page ... but I dont have any idea how to > override the sort function, because when the sort clicked, I want to > call my ajax function and doing sort from database. > > On May 7, 3:13 am, patrick davey <[EMAIL PROTECTED]> wrote: > > > Hi Kevin, > > > That looks like a really excellent plugin - might have to give it a > > try. The one thing it doesn't do that I need it to - is *filtering*. > > That is, say I am returning rows and one of the columns is a city - > > and there may be multiple rows with the same city data. I want to be > > able to choose 'Dublin' and then only have rows which have dublin as a > > city returned. > > > And then... I want to be able to continue sorting and paging through > > my ajax'd data! Fun eh ;) When I get something working I'll try to > > post it up somewhere... as long as I can make it readable etc! > > > Thanks, > > Patrick > > > On May 6, 9:47 pm, Kevin Kietel <[EMAIL PROTECTED]> wrote: > > > > Try Flexigrid! > > > >http://webplicity.net/flexigrid/ > > > > This jQuery plugin is a Lightweight but rich data grid with resizable > > > columns and a scrolling data to match the headers, plus an ability to > > > connect to an json/xml based data source using Ajax to load the > > > content. > > > > If you need any help implementing it, just contact me or take a look > > > at the Flexigrid discussion on CodeIgniter > > > forums:http://codeigniter.com/forums/viewthread/75326/ > > > There are several examples that you can use. > > > > Let me know if this is what you're looking for! > > > > Bye, > > > > Kevin > > > > On May 6, 2:18 am, patrick davey <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > > > I am using thetablesorterpluginghttp://tablesorter.com/andit > > > > works fine for smallish tables. However, I need to page through large > > > > result sets (and filter them) - so I am going to use AJAX to > > > > repopulate the table once the options have been selected. > > > > > Now, if through filtering / whetever - less than 100 rows are > > > > returned, then I wanttablesorterto just sort the table (without > > > > having to make an AJAX call) > > > > > To do this I want to edit thetablesorterplugin to call a function > > > > which returns true/false depending on how many records there are to > > > > sort. > > > > > So my question (there is one!) is how do I do that withtablesorter. > > > > I have tried using 'sortStart' and returning false but no joy. I can > > > > edit the source of course - but if there is a simple way I'd love to > > > > know it. > > > > > Better still, does anyone have an example of doing filtering&sorting& > > > > paging of large datasets using JSON/AJAX and Jquery? :) > > > > > Thanks, > > > > Patrick
