472,331 Members | 1,398 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,331 software developers and data experts.

code to sort a table

xah
i'm just starting out on javascript.

can anyone show me how to go about writing a code to sort a table
column?

something like the following:

<table border="1">
<tr>
<td>
<a href="" onClick="">sort me</a>
</td>
<tr>
<tr>
<td>
2
</td>
<tr>
<tr>
<td>
3
</td>
<tr>
<tr>
<td>
1
</td>
<tr>
</table>

i'm guessing that the code would first read in the table entries as
documents.table.[1].??, assign it as a array, then sort, then delete
the table text, then print the table text.

How to delete the table text?

eventually this would be for a multi-column and multi-row table (a
matrix), and each row or column can be clicked to sort, without
disturbing existing order. The click would act as toggle or reverse
sorting.

Xah
xa*@xahlee.org
∑ http://xahlee.org/

Aug 27 '05 #1
5 2243
xa*@xahlee.org wrote:
i'm just starting out on javascript.

can anyone show me how to go about writing a code to sort a table
column?

That's the same as trying to ride the Tour de France the first time you are
learning to ride a bike.

Start reading the FAQ (http://jibbering.com/FAQ/) and try something simpler.
something like the following:

<table border="1">
<tr>
<td>
<a href="" onClick="">sort me</a>
</td>
<tr>
<tr>
Perhaps you should start to learn some basic HTML too; the above snippet is
not valid HTML because of the non-closed <tr>.
i'm guessing that the code would first read in the table entries as
documents.table.[1].??, assign it as a array, then sort, then delete
the table text, then print the table text.

How to delete the table text?

Just to give you an idea what's involved, here is an example of how you
could do it:

<script type="text/javascript">
function sortTable() {
var tds = document.getElementsByTagName('TD');
var content = [], val;
for (var i = 1; i < tds.length; i++) {
if (val = tds[i].innerHTML.replace('/[^\d]+/g','')) {
content[i - 1] = val;
}
}

content.sort();
for (var i = 1; i < tds.length; i++) {
tds[i].innerHTML = content[i - 1];
}
}
</script>
</head>

<body>
<table border="1">
<tr>
<td>
<a href="#" onClick="sortTable(); return false">sort me</a>
[...]
eventually this would be for a multi-column and multi-row table (a
matrix), and each row or column can be clicked to sort, without
disturbing existing order. The click would act as toggle or reverse
sorting.


As said before, learn the language first.
JW

Aug 27 '05 #2

<xa*@xahlee.org> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...
i'm just starting out on javascript.

can anyone show me how to go about writing a code to sort a table
column?

I assume you don't really mean to "sort the column" but rather to sort ON
the table column, right? In other words when somebody clicks your control
all the rows should move as single units rather than JUST the column data,
right?

If so then don't both sorting the column - it's messy and annoying to work
with the DOM to fetch values and such.

Instead create a sortable data structure representing your table - probably
an array of objects. A single function would display the table from this
structure. Your control would perform the sort on the structure, then call
the "display" function.

I've an abstraction object that could help here (long URL):

http://www.depressedpress.com/depres...ered/Index.cfm

It abstracts the processing of an array of objects allowing you to create
them, add and delete from them, sort them, shuffle the contents, etc.

There's an example at the bottom of that page that shows you how to create
and sort a table in this way. You may be able to modifiy to your needs
easily enough.

Hope this helps,

Jim Davis

Aug 27 '05 #3
ASM
xa*@xahlee.org wrote:
i'm just starting out on javascript.


sorting a table is not possible if you are starting ...

http://www.kryogenix.org/code/browser/sorttable/
http://www.mattkruse.com/javascript/...ble/index.html
--
Stephane Moriaux et son [moins] vieux Mac
Aug 28 '05 #4
"ASM" <st*********************@wanadoo.fr.invalid> wrote in message
news:43**********************@news.wanadoo.fr...
xa*@xahlee.org wrote:
i'm just starting out on javascript.
sorting a table is not possible if you are starting ...


Well... perhaps a better way to say it is that if you end up being able to
sort a table then you're not starting out anymore. ;^)
http://www.kryogenix.org/code/browser/sorttable/
http://www.mattkruse.com/javascript/...ble/index.html


For what it's worth both of those example seem a lot more complex than they
need to be for the task - although they both, of course, worth just fine.
Regardless of how complex they are however they both provide decent
abstractions of that complexity so are useful to beginners.

Personally I don't see the utility of using the HTML of the table as the
data storage mechanism. I think thats what makes so many of these solutions
as complex as they are. Managing and sorting the data seprately from the
presentation is so very much simpler.

Jim Davis

Aug 28 '05 #5
ASM
Jim Davis wrote:
"ASM" <st*********************@wanadoo.fr.invalid> wrote in message
news:43**********************@news.wanadoo.fr...
xa*@xahlee.org wrote:
i'm just starting out on javascript.
sorting a table is not possible if you are starting ...

Well... perhaps a better way to say it is that if you end up being able to
sort a table then you're not starting out anymore. ;^)


:-)
http://www.kryogenix.org/code/browser/sorttable/
http://www.mattkruse.com/javascript/...ble/index.html


For what it's worth both of those example seem a lot more complex than they
need to be for the task - although they both, of course, worth just fine.
Regardless of how complex they are however they both provide decent
abstractions of that complexity so are useful to beginners.

Personally I don't see the utility of using the HTML of the table as the
data storage mechanism.


Question was : how to sort a table
on my idea the table is pre-existing
and to sort only on TD.innerHTML or TH is it less complex ?

Of course if you display a JS matrix in a table via document.write() or
else this way, it is a little simplier :
http://perso.wanadoo.fr/stephane.mor...ri_matrice.htm

I think thats what makes so many of these solutions as complex as they are. Managing and sorting the data seprately from the
presentation is so very much simpler.


I continue to think that function to sort a matrix is not easy to understand
could be seen here:
<http://groups.google.com/group/fr.comp.lang.javascript/msg/1ca86e2439894ee6?rnum=1>
--
Stephane Moriaux et son [moins] vieux Mac
Aug 28 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: jason | last post by:
Hello. Newbie on SQL and suffering through this. I have two tables created as such: drop table table1; go drop table table2; go
9
by: Raymond Lewallen | last post by:
I have a dataview in which the sort property will not sort the dataview. Here's is a simple scenario similar to what I am doing: Class Foo ...
3
by: Mel | last post by:
i need to sort my table based on a "header click". is there a generic code out there that does that for me, or i have to write one for each and...
8
by: bissatch | last post by:
Hi, I am about to create a table, where the values are taken from an XML file, where each column header you can click and it will sort the table...
1
by: Gunjan Garg | last post by:
Hello All, I am working to create a generic datagrid which accepts a datasource(ListData - This is our own datatype) and depending on the calling...
5
by: loc2006 | last post by:
I got this tablesort code from http://www.brainjar.com/dhtml/tablesort/default7.asp This is very slow for my table of 10 columns and 400 rows. Is...
4
by: donpro | last post by:
Hi, I've created a table where the header columns link to an AJAX function which calls a PHP file and returns content - the purpose is to sort...
3
by: Hazza | last post by:
Hi, I am using PHP and mysql to create a website. I am fairly new to PHP, and thus am grateful to anyone who helps! Firstly I am running a...
5
by: neocortex | last post by:
Hello! I am a newbie in Python. Recently, I get stuck with the problem of sorting by two criteria. In brief, I have a two-dimensional list (for a...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.