Table Widget for IE? Fixed header, sorting columns, etc

[Matt Kruse]

I'm looking for the best JS/CSS solution to add functionality to tables.
The only browser which needs to be supported is IE5.5+, but no activeX can
be used.

to be able to do:
- Fixed header row
- Data sorting (preferrably intelligently determining data type based on
content)
- If possible, locking the first column from scrolling

I've seen one solution at
http://web.tampabay.rr.com/bmerkey/e...olumn-csv.html which is
pretty good, but it uses a DIV that scrolls and puts the table within it,
making the header row move down as the DIV is scrolled. This works, but it's
not as elegant and simple as I'd like.

I wish IE would support tbody{scroll:au to} but we're not that lucky :(

--
Matt Kruse
http://www.JavascriptToolbox.com

[Harag]

On Wed, 1 Sep 2004 10:49:41 -0500, "Matt Kruse"
<ne********@mat tkruse.com> wrote:

I'm looking for the best JS/CSS solution to add functionality to tables.
The only browser which needs to be supported is IE5.5+, but no activeX can
be used.

to be able to do:
- Fixed header row
- Data sorting (preferrably intelligently determining data type based on
content)

Doesn't your sorting JS routine help you?

http://www.mattkruse.com/javascript/sorttable/

HTH lol

Al.
- If possible, locking the first column from scrolling

I've seen one solution at
http://web.tampabay.rr.com/bmerkey/e...olumn-csv.html which is
pretty good, but it uses a DIV that scrolls and puts the table within it,
making the header row move down as the DIV is scrolled. This works, but it's
not as elegant and simple as I'd like.

I wish IE would support tbody{scroll:au to} but we're not that lucky :(

[Matt Kruse]

Harag wrote:

Doesn't your sorting JS routine help you?
http://www.mattkruse.com/javascript/sorttable/
HTH lol

Nah, that's ancient and only around for NS4-supporters who still need
client-side sorting.
Which probably doesn't even exist as a requirement for anyone anymore, so
I'll go ahead and remove it when I get time...

--
Matt Kruse
http://www.JavascriptToolbox.com

[Harag]

On Thu, 2 Sep 2004 09:02:50 -0500, "Matt Kruse"
<ne********@mat tkruse.com> wrote:

Harag wrote:

Doesn't your sorting JS routine help you?
http://www.mattkruse.com/javascript/sorttable/
HTH lol

Nah, that's ancient and only around for NS4-supporters who still need
client-side sorting.
Which probably doesn't even exist as a requirement for anyone anymore, so
I'll go ahead and remove it when I get time...

No don't remove it... replace it :) when you find a cool sorting
script please list it.

Al.

[Dr John Stockton]

JRS: In article <ch*********@ne ws1.newsguy.com >, dated Wed, 1 Sep 2004
16:13:36, seen in news:comp.lang. javascript, Matt Kruse
<ne********@mat tkruse.com> posted :

Actually, I was thinking of just looking at the first 3-5 values. If they're
all numeric, use numeric sort. If they match \d+/\d+/\d+ then use date. Etc,
etc.

\d+/\d+/\d+ may be sufficient to suggest a date; but \d+-\d+-\d+ also
should suggest a date. One should not disregard US Federal standards,
even if they match international ones.

But that is not sufficient information to enable a sort.

The field order can be YMD, DMY, or MDY; which it is may be evident on
closer inspection, or may remain uncertain.

The year may be YYYY or YY; in the latter case, it will generally need
to be windowed into YYYY before sorting.

If the field is a sensible date, it can be sorted as a string; hence it
does not need to be recognised.

BTW, not only can YYYY-MM-DD be sorted as string, but YYYY-WW-D can.

--
© John Stockton, Surrey, UK. ?@merlyn.demon. co.uk Turnpike v4.00 MIME. ©
Web <URL:http://www.merlyn.demo n.co.uk/> - w. FAQish topics, links, acronyms
PAS EXE etc : <URL:http://www.merlyn.demo n.co.uk/programs/> - see 00index.htm
Dates - miscdate.htm moredate.htm js-dates.htm pas-time.htm critdate.htm etc.

[Mick White]

Matt Kruse wrote:

Mick White wrote:

http://mickweb.com/football/aleague/profiles.html
Something like this?

For purely sorting, that works. But it doesn't do it intelligently - it
requires a parameter to explicitly say what the data type is.

It would be easy enough to distinguish between String and Number. Just
test the first entry in the column, and select the appropriate sort
function. You can add your own rules for dates, heights, etc.
Mick

[Randy Webb]

Mick White wrote:

Matt Kruse wrote:

Mick White wrote:

http://mickweb.com/football/aleague/profiles.html
Something like this?

For purely sorting, that works. But it doesn't do it intelligently - it
requires a parameter to explicitly say what the data type is.

It would be easy enough to distinguish between String and Number. Just
test the first entry in the column, and select the appropriate sort
function. You can add your own rules for dates, heights, etc.

That won't work.

var s='1 day at a time';

Number or String?
--
Randy
comp.lang.javas cript FAQ - http://jibbering.com/faq

[Randy Webb]

Mick White wrote:

Matt Kruse wrote:

Mick White wrote:

http://mickweb.com/football/aleague/profiles.html
Something like this?

For purely sorting, that works. But it doesn't do it intelligently - it
requires a parameter to explicitly say what the data type is.

It would be easy enough to distinguish between String and Number. Just
test the first entry in the column, and select the appropriate sort
function. You can add your own rules for dates, heights, etc.
Mick

That won't work.

var s='1 day at a time';

Number or String?

--
Randy
comp.lang.javas cript FAQ - http://jibbering.com/faq

[Mick White]

Randy Webb wrote:

Mick White wrote:

It would be easy enough to distinguish between String and Number. Just
test the first entry in the column, and select the appropriate sort
function. You can add your own rules for dates, heights, etc.

That won't work.

var s='1 day at a time';

Number or String?

Neither, it's the start of a Baptist Hymn....
Mick