I saw some one do this with providing the table as xml and used xslt to convert the xml into html table. Then when they clicked a new sort of the table, the browser would go and get a new xslt file, apply it to the xml file and produce a new table that is sorted correctly. I liked this approach better.

Mark

 -----Original Message-----
 From: Tim Wood [mailto:timwood0@(protected)]
 Sent: Wed 9/24/2003 2:09 PM
 To: J2EE-INTEREST@(protected)
 Cc:
 Subject: Re: sorting query results in J2EE
 
 

 At 10:55 AM 09/24/03, Stan Ou wrote:
 >Hi all,
 >
 >I have a sql query that joins 5 or 6 tables that
 >returns 100 to 200 records. The result is wrapped in a
 >VO and is rendered in a JSP by html table. the user
 >can click one of the 4 column headings to sort the
 >result. what is the best to achieve this ? thanks in
 >advance.
 
 Run the query and dump the results into Javascript arrays generated by the JSP. Then have the Javascript do the sorting on the client side. Don't bother the database with it.
 TW
 
 ===========================================================================
 To unsubscribe, send email to listserv@(protected)
 of the message "signoff J2EE-INTEREST". For general help, send email to
 listserv@(protected)".