Err... I take that back. -the only way for the page to not have javascript errors is to put in the ExtractionType line, due to the special characters in the title.
-however, by doing this, any time you sort any other field, it still is sorting by title, not the field you actually clicked. --- Kim Johnson <[EMAIL PROTECTED]> wrote: > 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? > > > > > > === message truncated === ____________________________________________________________________________________ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase.yahoo.com/promo-generic-14795097