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
> > > :
> > > ((a[1] > b[1]) ? 1 : 0)); }
> > >
> > > I usually use MYSQL's sorting mechanisms to
> filter
> > > queries (var1 < var2) and this method works with
> > > special characters and such, so I'm not sure
> what
> > > the
> > > best way to modify the js file would be (for a
> > > temporary solution, until this is "fixed" in a
> > > subsequent release).
> > >
> > > Do you know of the reason why these cases are
> > > breaking, and/or what a good workaround would
> be?
> > >
> > > thanks,
> > > -kim
> > >
> > >
> > >
> > >
> > >
> >
> >
>
____________________________________________________________________________________
> > > No need to miss a message. Get email on-the-go
> > > with Yahoo! Mail for Mobile. Get started.
> > > http://mobile.yahoo.com/mail
> > >
> >
> >
> >
> >
> >
> >
>
____________________________________________________________________________________
> > 8:00? 8:25? 8:40? Find a flick in no time
> > with the Yahoo! Search movie showtime shortcut.
> > http://tools.search.yahoo.com/shortcuts/#news
> >
>
>
>
> --
> POLYESTER*
> Wittstocksgatan 2
> 115 24 Stockholm
> Phone: 08-660 73 50 / +46-8-660 73 50
> Mobile: 070-443 91 90 / +46-70-443 91 90
> E-mail: [EMAIL PROTECTED]
> http://www.polyester.se
>
____________________________________________________________________________________
Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives.
http://tools.search.yahoo.com/toolbar/features/mail/
--
POLYESTER*
Wittstocksgatan 2
115 24 Stockholm
Phone: 08-660 73 50 / +46-8-660 73 50
Mobile: 070-443 91 90 / +46-70-443 91 90
E-mail: [EMAIL PROTECTED]
http://www.polyester.se
