Javascript Sorting Problem
-
Ok here is the situation. I need to be able to sort a table of data that is returned in a paged recordset layout. The idea I am trying to create for the user is that if they click on the "Head" of the column once the data will be sorted descending, again and it will be sorted ascending. I have found a script on another site to do this however it doesn't work in Netscape and the application I am working on requires browser compliance across the board. Does anyone have any suggestions? Thanks in advance. P.S. - Right now the application will sort the entire contents of the returning results, I only want to sort descending or ascending of the 10 records per page that is being displayed. Nick Parker
-
Ok here is the situation. I need to be able to sort a table of data that is returned in a paged recordset layout. The idea I am trying to create for the user is that if they click on the "Head" of the column once the data will be sorted descending, again and it will be sorted ascending. I have found a script on another site to do this however it doesn't work in Netscape and the application I am working on requires browser compliance across the board. Does anyone have any suggestions? Thanks in advance. P.S. - Right now the application will sort the entire contents of the returning results, I only want to sort descending or ascending of the 10 records per page that is being displayed. Nick Parker
I assume you're talking about requesting the data again from the database, and not using dhtml (which could be he only reason why the script doesn't work with netscape) to sort the single page. Getting your 10 records from the database, in the right order within a single page, can only be done by requesting those specific records by ID. So you'll have to send the IDs of the records back to the server (hidden input) with the sort field. MS SQL: "SELECT * FROM myTable WHERE ID IN ("+myIDs+") ORDER BY "+orderField myIDs contains comma-separated IDs. Paging after sorting using a different field, will be a bit confusing though, as the user whould have to return to your default sort-order. - Morten
-
I assume you're talking about requesting the data again from the database, and not using dhtml (which could be he only reason why the script doesn't work with netscape) to sort the single page. Getting your 10 records from the database, in the right order within a single page, can only be done by requesting those specific records by ID. So you'll have to send the IDs of the records back to the server (hidden input) with the sort field. MS SQL: "SELECT * FROM myTable WHERE ID IN ("+myIDs+") ORDER BY "+orderField myIDs contains comma-separated IDs. Paging after sorting using a different field, will be a bit confusing though, as the user whould have to return to your default sort-order. - Morten
Morten Rasmussen wrote: I assume you're talking about requesting the data again from the database I am actually looking into methods that will allow me to sort the data without returning to the server. I do have a script that does this but it is only effective in IE. Thanks Nick Parker
-
Morten Rasmussen wrote: I assume you're talking about requesting the data again from the database I am actually looking into methods that will allow me to sort the data without returning to the server. I do have a script that does this but it is only effective in IE. Thanks Nick Parker
It can be done in the browser, including NS (but only NS6). Give all cells an ID. Cell_00_00 - Cell_00_01 - Cell_00_02 Cell_01_00 - Cell_01_01 - Cell_01_02 Cell_02_00 - Cell_02_01 - Cell_02_02 Create an Array for client-side javascript that contains all data (no need to read data from the table, before each sort). On click, sort the data (same array or to new array) and insert cell by cell. - Morten
-
It can be done in the browser, including NS (but only NS6). Give all cells an ID. Cell_00_00 - Cell_00_01 - Cell_00_02 Cell_01_00 - Cell_01_01 - Cell_01_02 Cell_02_00 - Cell_02_01 - Cell_02_02 Create an Array for client-side javascript that contains all data (no need to read data from the table, before each sort). On click, sort the data (same array or to new array) and insert cell by cell. - Morten
I beleive we are basing our tests off the earlier versions of Netscape 4. Seem to run into a brick wall everytime. :mad: Nick Parker
-
I beleive we are basing our tests off the earlier versions of Netscape 4. Seem to run into a brick wall everytime. :mad: Nick Parker
If you don't have any form elements in the table, you can try: http://www.mattkruse.com/javascript/sorttable/index.html It's not extremely stable in NS 4.x, but it works if you don't click around too fast (as all NS layering). The buttom sample works in NS. Not the top one, as it contains form elements. You must have a very insistent customer, since you're trying to implement it for NS 4.0x The user base is propably below 1 percent now, and why ruin the "experience" for users keeping up to date? - Morten
-
If you don't have any form elements in the table, you can try: http://www.mattkruse.com/javascript/sorttable/index.html It's not extremely stable in NS 4.x, but it works if you don't click around too fast (as all NS layering). The buttom sample works in NS. Not the top one, as it contains form elements. You must have a very insistent customer, since you're trying to implement it for NS 4.0x The user base is propably below 1 percent now, and why ruin the "experience" for users keeping up to date? - Morten
Morten Rasmussen wrote: The user base is propably below 1 percent now, and why ruin the "experience" for users keeping up to date? You are probably correct; the company I work for represents a conglomerate of independent telephone companies, none of which we can require them to use IE. Nick Parker
-
Morten Rasmussen wrote: The user base is propably below 1 percent now, and why ruin the "experience" for users keeping up to date? You are probably correct; the company I work for represents a conglomerate of independent telephone companies, none of which we can require them to use IE. Nick Parker
Still, if you have to use hours upon hours implementing a single feature that will at best work flakily in NS 4.x for what is most likely a small userbase (even in phone companies - unless they're using OS/2), the time could be used better developing other features. To get the "tablesort" to work a bit better in NS, you could disable the click event for the coloumn-headings until the table is redrawn. - Morten
-
Still, if you have to use hours upon hours implementing a single feature that will at best work flakily in NS 4.x for what is most likely a small userbase (even in phone companies - unless they're using OS/2), the time could be used better developing other features. To get the "tablesort" to work a bit better in NS, you could disable the click event for the coloumn-headings until the table is redrawn. - Morten