A simple solution would be to ditch the resultset and convert it to XML.
Then you can use XML/XSL and DOM to sort it easy with an "order-by". This
is a effective solution if you are already using XML and loading stuff into
the parser DOM.
-Michael
-----Original Message-----
From: Jyoti Bongarala [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 19, 2000 9:16 AM
To: [EMAIL PROTECTED]
Subject: [JSP-INTEREST] (Very very urgent)Sorting a resultset after
closing the connection
HI all,
My problem is I am looking for an algorithm or a
program that would do the following :
1. Once I retrieve a resultset from the database, I
store it in a CachedRowSet. And when I display it ,
the user should be able to sort the data by any column
(total columns retrieved are 13) and this sorting has
to be done (outside the database)
Please somebody help me with this or give me a
lead....
thanks,
Jyoti
__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
