Re: Sorting html tables dynamically
On Wed, 4 Aug 2004, Anna Bikkina wrote: I am developing a server that displays historical information of a set of activities.Sometimes for a particular day the no of rows would be 9000. They are obtained from a database using a stored procedure which I call in my xsp and converted to html using xsl. They is no hard requirement that they have to be displayed all at once but then we have been doing it for a long time. Now the clients come up with this requirement of sorting... Anna. when i have to get sorted data i sort them in sql query so data in produced xml are already in order i want. its must faster to ask your database to sort your data rather xsl or a client side aproach. -- stavros On Wednesday 04 August 2004 02:07 pm, [EMAIL PROTECTED] wrote: On Wed, 4 Aug 2004, Anna Bikkina wrote: Thank you for the responses. Brainjar's script might not work for me. I have 1000's of rows in my table. Typically there are around 9000 rows this might not work for me. Anna. hi anna can i ask you how do you produce this amount of rows ? and why do you want o display all at once ? -- stavros On Wednesday 04 August 2004 07:07 am, FREDERIC MOSER wrote: Client side table sorting using javascript (like http://brainjar.com/dhtml/tablesort/) is a really cool concept but if you have a lot of rows, your browser might get very slow and crash. yes thats true, but in most cases so many rows that can crash or slowdown browser its not a good idea to be displayed to the user too. i have no problem sorting some hundred rows (in IE). -- stavros I must admit I used brainjar's script pretty much out of the box. I never succeed sorting hundred of rows with a reasonable speed (depends on what you're sorting of course...). But I still like the idea a lot so I would be curious to see how you're doing it. Thanks in advance, Fred - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Sorting html tables dynamically
Anna I am not a cocoon portal user (yet!) but normally I handle sorting in the stylesheet that is generating that HTML table; add a ?sort=xyz to the hyperlink (usually wrapped around the column title) and access this in the stylesheet to perform the sort. I suspect you'll have to dig into the code that the portal is using to create its pages. HTH Derek [EMAIL PROTECTED] 2004/08/03 10:38:06 PM Hi, I have a cocoon portal appliation that displays information in html tables. I have to provide sorting of columns in this table to users. How can we do this? Can someone please shed some light on this and send me some code snippets. Thanks, Anna. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. MailScanner thanks transtec Computers for their support. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Sorting html tables dynamically
On Wed, 4 Aug 2004, Derek Hohls wrote: Anna I am not a cocoon portal user (yet!) but normally I handle sorting in the stylesheet that is generating that HTML table; add a ?sort=xyz to the hyperlink (usually wrapped around the column title) and access this in the stylesheet to perform the sort. I suspect you'll have to dig into the code that the portal is using to create its pages. HTH Derek [EMAIL PROTECTED] 2004/08/03 10:38:06 PM Hi, I have a cocoon portal appliation that displays information in html tables. I have to provide sorting of columns in this table to users. How can we do this? Can someone please shed some light on this and send me some code i will choose to use a client side javascript that will dynamic sort table's rows -- stavros snippets. Thanks, Anna. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Sorting html tables dynamically
i will choose to use a client side javascript that will dynamic sort table's rows -- stavros Client side table sorting using javascript (like http://brainjar.com/dhtml/tablesort/) is a really cool concept but if you have a lot of rows, your browser might get very slow and crash. I took it off from all my pages after users complained. Cheers Fred - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Sorting html tables dynamically
On Wed, 4 Aug 2004, FREDERIC MOSER wrote: i will choose to use a client side javascript that will dynamic sort table's rows -- stavros Client side table sorting using javascript (like http://brainjar.com/dhtml/tablesort/) is a really cool concept but if you have a lot of rows, your browser might get very slow and crash. yes thats true, but in most cases so many rows that can crash or slowdown browser its not a good idea to be displayed to the user too. i have no problem sorting some hundred rows (in IE). -- stavros I took it off from all my pages after users complained. Cheers Fred - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Sorting html tables dynamically
Client side table sorting using javascript (like http://brainjar.com/dhtml/tablesort/) is a really cool concept but if you have a lot of rows, your browser might get very slow and crash. yes thats true, but in most cases so many rows that can crash or slowdown browser its not a good idea to be displayed to the user too. i have no problem sorting some hundred rows (in IE). -- stavros I must admit I used brainjar's script pretty much out of the box. I never succeed sorting hundred of rows with a reasonable speed (depends on what you're sorting of course...). But I still like the idea a lot so I would be curious to see how you're doing it. Thanks in advance, Fred - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Sorting html tables dynamically
On Wed, 4 Aug 2004, FREDERIC MOSER wrote: Client side table sorting using javascript (like http://brainjar.com/dhtml/tablesort/) is a really cool concept but if you have a lot of rows, your browser might get very slow and crash. yes thats true, but in most cases so many rows that can crash or slowdown browser its not a good idea to be displayed to the user too. i have no problem sorting some hundred rows (in IE). -- stavros i use microsoft's .htc behaviors to do think like that (work only on IE) take a look here http://tools.osmosis.gr/pubftp/table_sort/demo.html ps -- every time i had to configure an .htc to work under cocoon i must to spend many hours :-( -- stavros I must admit I used brainjar's script pretty much out of the box. I never succeed sorting hundred of rows with a reasonable speed (depends on what you're sorting of course...). But I still like the idea a lot so I would be curious to see how you're doing it. Thanks in advance, Fred - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Sorting html tables dynamically
Thank you for the responses. Brainjar's script might not work for me. I have 1000's of rows in my table. Typically there are around 9000 rows this might not work for me. Anna. On Wednesday 04 August 2004 07:07 am, FREDERIC MOSER wrote: Client side table sorting using javascript (like http://brainjar.com/dhtml/tablesort/) is a really cool concept but if you have a lot of rows, your browser might get very slow and crash. yes thats true, but in most cases so many rows that can crash or slowdown browser its not a good idea to be displayed to the user too. i have no problem sorting some hundred rows (in IE). -- stavros I must admit I used brainjar's script pretty much out of the box. I never succeed sorting hundred of rows with a reasonable speed (depends on what you're sorting of course...). But I still like the idea a lot so I would be curious to see how you're doing it. Thanks in advance, Fred - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Sorting html tables dynamically
Can anyone please send me a snippet of how to use xsl:sort. Anna. On Wednesday 04 August 2004 08:38 am, [EMAIL PROTECTED] wrote: On Wed, 4 Aug 2004, FREDERIC MOSER wrote: Client side table sorting using javascript (like http://brainjar.com/dhtml/tablesort/) is a really cool concept but if you have a lot of rows, your browser might get very slow and crash. yes thats true, but in most cases so many rows that can crash or slowdown browser its not a good idea to be displayed to the user too. i have no problem sorting some hundred rows (in IE). -- stavros i use microsoft's .htc behaviors to do think like that (work only on IE) take a look here http://tools.osmosis.gr/pubftp/table_sort/demo.html ps -- every time i had to configure an .htc to work under cocoon i must to spend many hours :-( -- stavros I must admit I used brainjar's script pretty much out of the box. I never succeed sorting hundred of rows with a reasonable speed (depends on what you're sorting of course...). But I still like the idea a lot so I would be curious to see how you're doing it. Thanks in advance, Fred - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Sorting html tables dynamically
Anna, Yet another client-side approach is to look at Domapi www.domapi.com. IIRC he's implemented a sortable Grid that uses rpc to talk to the server to pull data. That way he can support paging and other dynamic activities. I think he is using JSON as the wire representation of the data sets. HTH, Steve I have a cocoon portal appliation that displays information in html tables. I have to provide sorting of columns in this table to users. How can we do this? Can someone please shed some light on this and send me some code snippets. _ MSN Toolbar provides one-click access to Hotmail from any Web page FREE download! http://toolbar.msn.click-url.com/go/onm00200413ave/direct/01/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Sorting html tables dynamically
Anna Bikkina wrote: Can anyone please send me a snippet of how to use xsl:sort. Anna. Here are samples for most XSLT elements: http://zvon.org/xxl/XSLTutorial/Output/elementIndex.html HTH -- Volkmar W. Pogatzki - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Sorting html tables dynamically
This is an old implementation I did. ?xml version=1.0 encoding=ISO-8859-1? xsl:stylesheet version=1.0 xmlns:xsl=http://www.w3.org/1999/XSL/Transform; xsl:template match=* xsl:copy xsl:apply-templates/ /xsl:copy /xsl:template xsl:template match=Items Items xsl:for-each select=Item !-- sort item by category then sku, then copy results to output doc -- xsl:sort select=Category/ xsl:sort select=SKU/ xsl:copy-of select=./ /xsl:for-each /Items /xsl:template /xsl:stylesheet I had used this in a pipeline to first sort my data, then format the results with a different stylesheet. Separating the processes immensely increased the overall speed. -andy Anna Bikkina wrote: Can anyone please send me a snippet of how to use xsl:sort. Anna. On Wednesday 04 August 2004 08:38 am, [EMAIL PROTECTED] wrote: On Wed, 4 Aug 2004, FREDERIC MOSER wrote: Client side table sorting using javascript (like http://brainjar.com/dhtml/tablesort/) is a really cool concept but if you have a lot of rows, your browser might get very slow and crash. yes thats true, but in most cases so many rows that can crash or slowdown browser its not a good idea to be displayed to the user too. i have no problem sorting some hundred rows (in IE). -- stavros i use microsoft's .htc behaviors to do think like that (work only on IE) take a look here http://tools.osmosis.gr/pubftp/table_sort/demo.html ps -- every time i had to configure an .htc to work under cocoon i must to spend many hours :-( -- stavros I must admit I used brainjar's script pretty much out of the box. I never succeed sorting hundred of rows with a reasonable speed (depends on what you're sorting of course...). But I still like the idea a lot so I would be curious to see how you're doing it. Thanks in advance, Fred - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Andrew Stone [EMAIL PROTECTED] v) 678.385.2823 XML Architect/Developer Brightlane, a Teamstaff, Inc. Company - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Sorting html tables dynamically
On Wed, 4 Aug 2004, Anna Bikkina wrote: Thank you for the responses. Brainjar's script might not work for me. I have 1000's of rows in my table. Typically there are around 9000 rows this might not work for me. Anna. hi anna can i ask you how do you produce this amount of rows ? and why do you want o display all at once ? -- stavros On Wednesday 04 August 2004 07:07 am, FREDERIC MOSER wrote: Client side table sorting using javascript (like http://brainjar.com/dhtml/tablesort/) is a really cool concept but if you have a lot of rows, your browser might get very slow and crash. yes thats true, but in most cases so many rows that can crash or slowdown browser its not a good idea to be displayed to the user too. i have no problem sorting some hundred rows (in IE). -- stavros I must admit I used brainjar's script pretty much out of the box. I never succeed sorting hundred of rows with a reasonable speed (depends on what you're sorting of course...). But I still like the idea a lot so I would be curious to see how you're doing it. Thanks in advance, Fred - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Sorting html tables dynamically
I am developing a server that displays historical information of a set of activities.Sometimes for a particular day the no of rows would be 9000. They are obtained from a database using a stored procedure which I call in my xsp and converted to html using xsl. They is no hard requirement that they have to be displayed all at once but then we have been doing it for a long time. Now the clients come up with this requirement of sorting... Anna. On Wednesday 04 August 2004 02:07 pm, [EMAIL PROTECTED] wrote: On Wed, 4 Aug 2004, Anna Bikkina wrote: Thank you for the responses. Brainjar's script might not work for me. I have 1000's of rows in my table. Typically there are around 9000 rows this might not work for me. Anna. hi anna can i ask you how do you produce this amount of rows ? and why do you want o display all at once ? -- stavros On Wednesday 04 August 2004 07:07 am, FREDERIC MOSER wrote: Client side table sorting using javascript (like http://brainjar.com/dhtml/tablesort/) is a really cool concept but if you have a lot of rows, your browser might get very slow and crash. yes thats true, but in most cases so many rows that can crash or slowdown browser its not a good idea to be displayed to the user too. i have no problem sorting some hundred rows (in IE). -- stavros I must admit I used brainjar's script pretty much out of the box. I never succeed sorting hundred of rows with a reasonable speed (depends on what you're sorting of course...). But I still like the idea a lot so I would be curious to see how you're doing it. Thanks in advance, Fred - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Sorting html tables dynamically
Hi, I have a cocoon portal appliation that displays information in html tables. I have to provide sorting of columns in this table to users. How can we do this? Can someone please shed some light on this and send me some code snippets. Thanks, Anna. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]