[jQuery] tableSorter - problems with changing the number of rows
I'm using the tableSorter plugin and am having a problem with the
number of rows displayed; I hope I can describe the situation clearly.
I'm building my table dynamically from a local javascript array,
initially populated with a database query. Next, I call the
tableSorter function. So far so good.
Next, I click a button to apply a filter. I clear out my table body's
contents with
$('#bodytable > tbody').empty();
I fill it up again by looping through my data, but this time skipping
certain rows, ending up with a smaller table. When I click on a column
head to redisplay, it thinks I had the number of rows that were
originally in the table, and doesn't sort correctly. It I have a
filter on when I load the page and end up with 5 rows, then remove the
filter and repopulate the table with ten rows, they all get displayed.
But when I click to sort, only 5 rows are displayed.
I want to avoid having to refresh the page, and am hoping there is
something I can do to tell tableSorter to recalculate the table size
after I have repopulated the table.
I tried setting useCache to false, but that didn't help. I've tried
calling $("#bodytable").tableSorter() again, hoping it would reset
everything, but that didn't help either. Is there a way to force it to
do a recalc?
Thanks for your help, this is a great group.