as days pass by, by Stuart Langridge

It may or may not be the same codebase, but Plone has this out of the box (and has had for a year or so).

It may or may not be the same codebase, but http://www.plone.org has this out of the box (and has had for a year or so).

That demo was absolutely the fastest sorting of a table on the web that I’ve ever experienced. That blows away any ActiveX garbage just for the simple fact that I don’t have to wait for the ActiveX to load. Bravo! Well done!

OK, sorry to hijack the thread, but I did manage to get this working in a rather kludgy way by adding a function call at the end of ts_resortTable. I’d be open to a simpler approach.

function ts_resortTable(lnk) {
...
...
altcolor(table);
span.innerHTML = ARROW;
}

function altcolor(tbl) {
var row=document.getElementById(tbl.id).getElementsByTagName(‘tr‘)
var l=row.length
for (i=0;i
if (i%2 == 0){row[i].className=‘C0‘}
else {r[i].className=‘C1‘;}
}

}

I thought this would work as we walk the rows in ts_resortTable but it isn’t:

newRows[i].className = “C” + (i%2);

Brilliant! In my tables I’m coloring alternating rows using class=“C0” or “C1” on a row. I can’t figure out how to keep the pattern correct when a sort has been applied. Any ideas?

It’s Ruby, so you’re roughly 2.4 times more wrong than if it’d have been Python :-)

Beautiful work, as always. Thanks for sharing.

Stop it, y‘bugger, I want to carry on hating javascript :-)

Hi

Anyone has readymade dom for paging of data like google style.

sorttable.js is pretty cool, but we’ve been using a hacked version – sorttable_colored.js – available from http://uzilla.net/uzilla/blog/credits.cfm which makes alternating row coloring in the table rows.

Today we just switched to another version – sorttable_colored_cookie.js – which uses cookies to remember the most recent sorting used.

It’s available from:
http://netfactory.dk/technology/markup/javascript/

Hmm. It doesn’t seem to work in Safari. That seems a shame. The small static WebFX version with hidden headers and buttons does work, but Safari doesn’t seem to like any of the versions where you directly click the headers.

how do I tell it not to add the sorting to a column?

This script is amazing!

one question:

Is there an easy way to ignore a row, say by class or id?

i love this script and it works great for my purposes, but a MAC owner told me it doesn't work properly. he said when he clicks on a header to sort, it sorts the first few properly, but then sorts randomly after that. any ideas?

It seems to have a "problem" on IE6 where if all the contents of a column are the same, you get an ugly error icon in the status bar. Obviously it doesn't change the way the page works, but it makes you look bad.

Apart from that it's great, thanks.

I'm looking for an easy-to-use sortable table that will read the data from and xml file? Anyone know of one?

Thanks

Hello,

I found this to be a REALLY great tool and decided to add proper support for sorting IP Addresses. I just convert a dotted decimal IP address into an integer value and sort on that. It actually works pretty fast considering. It could probably be optimized more but it works for me.

I added the following line in the ts_resortTable(lnk,clid) function at the bottom of the list of other similar statements:

if (itm.match(/^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}/)) sortfn = ts_sort_ip_address;

Then I added the functions here at appropriate spaces for clarity:

function ts_sort_ip_address(a,b) {

aa = ts_aton(ts_getInnerText(a.cells[SORT_COLUMN_INDEX]));

bb = ts_aton(ts_getInnerText(b.cells[SORT_COLUMN_INDEX]));

if(aa==bb) return 0;

if(aa

function ts_sort_ip_address(a,b) {

aa = ts_aton(ts_getInnerText(a.cells[SORT_COLUMN_INDEX]));

bb = ts_aton(ts_getInnerText(b.cells[SORT_COLUMN_INDEX]));

if(aa==bb) return 0;

if(aa

Sorry for the multiple posts. Apparently there is a limited length!

And also the function below to finish things out:

function ts_aton($dottedIpStr) {

var result = 0;

var C = [16777216,65536,256,1];

var nums = $dottedIpStr.split(/\./g);

for(i=0;i

// Remainder of function!

for(i=0;i

for(i=0;i

Ok, you'll just have to e-mail me for the full source! (normanh+spam@gmail.com)

Hi

Really cool script.

Is it possible to ignore a certain number of rows at the bottom of the table where totals would go?

Great script! Very usable. I was thinking if there's anyway that it can't while ignoring the case. Currently items with lower case goes AFTER those that starts with an upper case.

Great script.

Is it possible to use the script if table headers are in a different table?

For right sorting IP addresses add this function at the end of script:

function inet_aton(a){

var octets = a.split(/\./);

while (octets.length < 4) octets.splice(1,0,0);

var n = 0;

for (var i = 0; i < 4; i++) n = (n * 256) + parseInt(octets[i]);

return n;

}

And put this after sort_numeric:

sort_ip: function(a,b) {

aa = inet_aton(a[0]);

bb = inet_aton(b[0]);

if (aa==bb) return 0;

if (aa<bb) return -1;

return 1;

},

For using IP sorting you have to set the class in of this column:

IP address

If you have problems if it mail me : farid D0T adigamov AT gmail D0T com

For using IP sorting you have to set the class in of this column:

<th class="sorttable_ip">IP address</th>

If you have problems if it mail me : farid D0T adigamov AT gmail D0T com