Problem with Sort Table JavaScript? 1

[Happy100]

Hi

I have kindly been given an example of a JavaScript to sort tables. -

http://www.mickweb.com/javascript/demo/sort.html

http://www.comestaywithus.com/demo2.html

I have added the script to my page above. I've got it to work,
all except the Weekly Rates column and I think that because
I have numeric and text on the same column.

Can anyone advise what JavaScript code change is needed for this?

Many thanks

Happy

 

[mwolf00]

Take a look at this code:

Using JavaScript And DOM to Sort a Table faq216-3599

You will see that the code determines the datatype of the column and sorts based on that.

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

Tsunami Relief Information​

 

[Happy100]

Hi mwolf00

Many thanks for the referal link, it's just the job!
However, I'm very new to Javascript and I want to add another column.
Do I just create the column and hyperlink the the word in the top row with 'javascript: sortTable(4)', ie just keep adding the next number in the brackets per row?
Or does the number in the brackets tell the script how to sort it?

Many thanks

Happy.

 

[mwolf00]

All you need is 'javascript: sortTable(4)' and so on. The code will look at each input in the row and attempt to turn it into a Date type, if it fails, it trys to turn it into a number, if that fails, it assumes text. Once one field is determined to be text, the whole column is sorted as such. If none are text, but at least one is numeric, the whole column is sorted as such. If nothing but dates were found, then that is used for the sort...

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

Tsunami Relief Information​

 

[Happy100]

Hi again,

I have two tables on my pages, is there a way to get both tables working with the sort javascript on the same page?

Also I have a column with mixed alpha and numerical values. eg. 100 - 300, From 90.00, From 195.00 and the script see's the 100 - 300 and From 195.00 as lower values than From 90.00.
Is there a way to change this in the script?

Many thanks

Happy.

 

[mwolf00]

You can make it work with more than I table by using a second parameter...

'javascript: sortTable(4[blue],"tableIDgoesHere"[/blue])'

then inside of sortTable, you need to change

function sortTable(col[blue], inTable[/blue]){
    [red]// some lines omitted for clarity[/red]
    allTR = document.getElementById([blue]inTable[/blue]).childNodes[0].childNodes

As for mixed value columns, they will be sorted as text - try to see if you can change the way the data is listed...



Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

Tsunami Relief Information​

 

[Happy100]

Sorry to be a pain, I'm pretty new to Javascript!

Could you advise me on the exact location for these two extra pieces of script?
Does the first go in the html body and the second in the script somewhere?

Many thanks

Happy.

 

[Happy100]

Ok, I think I've worked out where the inTable code is added to the script, still not sure about the 'javascript: sortTable(4,"tableIDgoesHere")' though?

 

[mwolf00]

<table id=[blue]"dataTable1"[/blue] border=1 cellspacing=0>
<tr>
    <th><a href="javascript: sortTable(0, [blue]"dataTable1"[/blue])">Data Field</a></th>
    <th><a href="javascript: sortTable(1, [blue]"dataTable1"[/blue])">Number Field</a></th>
    <th><a href="javascript: sortTable(2, [blue]"dataTable1"[/blue])">Date Field</a></th>
    <th><a href="javascript: sortTable(3, [blue]"dataTable1"[/blue])">Mixed Field</a></th>
</tr>
..
..
..
</table>

<table id=[blue]"dataTable2"[/blue] border=1 cellspacing=0>
<tr>
    <th><a href="javascript: sortTable(0, [blue]"dataTable2"[/blue])">Data Field</a></th>
    <th><a href="javascript: sortTable(1, [blue]"dataTable2"[/blue])">Number Field</a></th>
    <th><a href="javascript: sortTable(2, [blue]"dataTable2"[/blue])">Date Field</a></th>
    <th><a href="javascript: sortTable(3, [blue]"dataTable2"[/blue])">Mixed Field</a></th>
</tr>
...
...
...
</table>

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

Tsunami Relief Information​

 

[Happy100]

Hi again,

I know it's a pain and I quite understand if you've had enough! But I think we are nearly there?

I've set the page exactly as descibed, but we get an error on line 14?

http://www.comestaywithus.com/sorttable.html

Many thanks, Happy.

 

[mwolf00]

	<th><a href="javascript: sortTable(0, [blue]'dataTable1'[/blue])">Data Field</a></th>
	<th><a href="javascript: sortTable(1, [blue]'dataTable1')[/blue]">Number Field</a></th>
	<th><a href="javascript: sortTable(2, [blue]'dataTable1'[/blue])">Date Field</a></th>
	<th><a href="javascript: sortTable(3, [blue]'dataTable1'[/blue])">Mixed Field</a></th>
	<th><a href="javascript: sortTable(4, [blue]'dataTable1'[/blue])">Rooms</a></th>

Sorry about that. Wasn't paying enough attention to context - you need single quotes around the second parameter since the call is in double quotes...

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

Tsunami Relief Information​

 

[Happy100]

Hi and a big thanks for that, I have one more little challenge, if anyone can help me figure this out?

All the script works a treat, but I have a column with mixed values that just don't work out right, please see -

http://www.comestaywithus.com/sorttable.html

The pricing columns need to show as low-high/high-low prices, but at the moment they are all over the place, because of the mixed values, which can't really be changed.
So I would imagine the script need to be altered, if possible?

Many thanks

Happy.

 

[mwolf00]

Is there any way to normalize the input? For instance, could you give the least expensive set 1 (£) sign and the most expensive 5 (£££££)?


Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

Tsunami Relief Information​

 

[Happy100]

I'm not too sure what you mean with the (£)signs, here is a good example of one of the 100's of pages I would need to use it on -

http://www.comestaywithus.com/england1/yorkshire-york.html

I could change it, so all the From prices read prices+ eg. 195.00+, instead of From 195.00?
Not sure if that helps though?

Also I've been told it doesn't seem work on other browsers, other than IE?

Am I asking too much for this to be possible to work?

Thanks, Happy.

 

[mwolf00]

Can you label the column "Weekly Rates From" and then just include one number making the column numeric? If not, the column will be seen as text and the only way to make it sort correctly would be to put a "0" in front of the 2-digit prices which wouldn't look too good...

"045"
"095"
"125"

I will see why the code doesn't run in NetScape and get back to you...

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

Tsunami Relief Information​

 

[Happy100]

Yes, I could change the Self Catering section to weekly from prices eg.

http://www.comestaywithus.com/sorttable2.html

But the script see's 95.00 as a higher value than 195.00?

But I would have more problems with the serviced section as these are priced with different values, eg some as room rate and some per person per night.
I take it, it's not possible for the script to ignore alpha char and only look at the numerical?

Many thanks, Happy.

 

[mwolf00]

Happy,

The code is written to try to figure out the best way to sort. You could write a similar code that does not try to do that and pass a parameter to that function indicating the best way to sort the column. The current code that you are using is limited in that as soon as any non-numeric data is detected, the whole column is sorted as text and, in text, "95" is greater than "195" but "095" is less than "195". The advantage of the code is that it is very easy to implement on normalized data whereas a function requiring you to tell it how to sort would be less easy (but not undoable).

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

Tsunami Relief Information​

 

[Happy100]

Is it something to could write, for a fee?

 

[mwolf00]

won't do it for a fee - not on this site - will try to post it here soon.

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

Tsunami Relief Information​

 

[Happy100]

mwolf00

That is really very good of you!
I promise you, your time and effort it is very much appreciated!

If you need any info from me, please let me know.

Many thanks

Happy.