why don't you use the "order by" clause.

-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of Salian, Santosh (GXS,
TCS)
Sent: Wednesday, November 29, 2000 12:25 AM
To: [EMAIL PROTECTED]
Subject: Sorting a Table based on any of the columns


Hi ,

I have a page to develop in which I need to display a table.
The data for which is picked from Oracle database.

But the user will be sorting that table based on any of the columns in
asc./desc. order.

Probably the easiest way to do this is querying the database n no. of times.
But thats definitely not efficient.

So are u aware of any way to have a (very) efficient code to incorporate
this feature........

Thanks and Regards,
Santosh

===========================================================================
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

Reply via email to