Super close, but not quite! :) http://anime-planet.com/users/reviewindex.php?usersid=1
$("#userreviewtable").tableSorter({ sortColumn: 'title', stripingRowClass: ['alt2','alt'], stripeRowsOnStartUp: true, textExtractionCustom: [ [2,'integer'] ], textExtractionType: ['title'] }); ExtractionType fixes the title issue -- those sort just fine now. I also changed the date to 4 digits and that works just fine (it didn't work with the date line you had mentioned for 2 digits). However, the Custom line still doesn't do anything for sorting the score field. (I removed the 0's, as normally those fields would be BLANK, as opposed to 0). I also tried changing [2, 'integer'] to 'decimal' or 'double', to no avail. Any ideas on this last tiny bit? thanks again, -kim --- Christian Bach <[EMAIL PROTECTED]> wrote: > I took a look at your example page and this snippet > will solve your problem: > > $("#userreviewtable").tableSorter({ > sortColumn: 'title', > stripingRowClass: ['alt2','alt'], > stripeRowsOnStartUp: true, > textExtractionCustom: [ > [2,'integer'] > ], > dateFormat: "dd/mm/yy" > }); > > > What we are doing here is forcing the third column > (we start counting at > zero) to use the integer parser, > since the column is messed up with the auto > detection and identified as a > text column (hey, no ones perfect). > > As regarding your date format 01/01/07 i have added > this to the shortDate > parser, however since the year is > formatted with two digests the parser will parse 07 > as 1997 since there is > no way for it to know that you > properly mean 2007. So my suggestion is to change > this to a full 4 digit > year format. > > If you do change the the year to a 4 digit format > remove the dateFormat > property from the tablesorter constructor. > > > The new tablesorter version can be found here: > http://dev.jquery.com/browser/trunk/plugins/tablesorter/jquery.tablesorter.js?format=txt > > Best regards > Christian > > > 2007/4/5, Kim Johnson <[EMAIL PROTECTED]>: > > > > > > Thanks Christian! > > > > I just pasted that in and indeed, now there isn't > a JS > > error and it sorts correctly by title. However, > now > > something strange is happening and the other > fields > > don't sort -- they all sort by title! The date > > specifically is what I just tried. > > > > Here are two sample pages: > > > > > http://anime-planet.com/users/reviewindex.php?usersid=19 > > > > ^^this page has always worked, because it has no > > special character names > > > > > http://anime-planet.com/users/reviewindex.php?usersid=1 > > ^^the "problem child" page. The title does now > work. > > > > Also, here's the tablesorter initialization: > > > > $("#userreviewtable").tableSorter({ > > sortColumn: 'title', > > stripingRowClass: ['alt2','alt'], > > stripeRowsOnStartUp: true, > > textExtractionType: ['title'] > > }); > > > > And one other question: is it possible to do > multiple > > columns for textExtraction (using a comma, two > > separate lines for it, etc)? There is one other > column > > (score) that in theory should be able to have > either > > nothing, or a number. > > > > Note: I'm still down with helping you on the > > documentation front :) > > > > thanks! > > -kim > > > > --- Christian Bach <[EMAIL PROTECTED]> > > wrote: > > > > > Kim, is it possible to publish a test page so i > can > > > take a look? > > > > > > > > > A "quick fix" would be to use the new property > > > textExtractionType - which in > > > true tablesorter spirit is undocumented. > > > > > > > > > > > > Here is a example: > > > > > > This forces the tablesorter to extract data out > of > > > the title attribute, > > > allowing a simple way to present mixed data to > the > > > user > > > (string/numbers/etc). > > > > > > <script> > > > $("table").tableSorter({ > > > textExtractionType: ['title'] > > > }); > > > > > > </script> > > > <table> > > > <thead> > > > <tr> > > > <th>Row</th> > > > <th>Number</th> > > > > > > </tr> > > > </thead> > > > <tbody> > > > <tr> > > > <td title="1">One</td> > > > <td title="30">30.0000000000</td> > > > </tr> > > > <tr> > > > <td title="2">2</td> > > > <td title="50"><a > href="50.00000000000</td> > > > </tr> > > > </tbody> > > > </table> > > > > > > > > > > > > Best regards > > > Christian > > > > > > > > > 2007/4/5, Kim Johnson <[EMAIL PROTECTED]>: > > > > > > > > > > > > Anyone know a workaround for this? :) > Christian, > > > any > > > > thoughts? > > > > > > > > -kim, who would really like to not code a > bunch of > > > > tablesorting tonight in php ;) > > > > > > > > --- Kim Johnson <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > ATTN: Christian or anyone else familiar :) > > > > > > > > > > I'm trying to use TableSorter for a few > large > > > > > batches > > > > > of data, but am getting JS errors depending > on > > > what > > > > > content is in the columns. > > > > > > > > > > For example: > > > > > > > > > > -Digit-only data works, but MIXED data (ex: > some > > > > > fields are empty, and some have decimal > values) > > > > > fails. > > > > > > > > > > -Special characters break the sorting. For > > > example, > > > > > I > > > > > have a list of titles and some titles start > with > > > > > special characters (ex: .hack//SIGN, ~To > > > Heart~). > > > > > This > > > > > also breaks. > > > > > > > > > > I suspect these are breaking because of > > > something to > > > > > do with the generic sorting function: > > > > > > > > > > generic: function(a,b) { return ((a[1] < > b[1]) ? > > > -1 > === message truncated === ____________________________________________________________________________________ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265