Sorting column in a html table 2003-12-23 - By Campano, Troy
Back
Well, if you're connected to a database, you can put in the
corresponding table name and sort on that column. The link in the table
header would have something like this in the URL:
MyPage.jsp?sort=UserName
...and then your SQL would say:
sSQL += "SELECT col1,col2,col3,UserName,Address \n";
sSQL += "FROM mytable \n";
sSQL += "ORDER BY " + request.getParameter("sSQL") + "\n";
thanks!
~ Troy Campano ~
-- --Original Message-- --
From: A mailing list about Java Server Pages specification and reference
[mailto:JSP-INTEREST@(protected)] On Behalf Of Renato Eschini
Sent: Tuesday, December 23, 2003 6:20 AM
To: JSP-INTEREST@(protected)
Subject: Sorting column in a html table
Some one know a pattern or mecchanism for sorting column in a html
table?
By for example clicking in a header of column sorting ascending and
discending..
Thanks all
Ciao e buon lavoro,
Renato
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
Renato Eschini
Synapsis S.r.l.
in Computer Science
P.zza Dante, 19/20
57121 Livorno Italy
tel: +39 0586 426790
fax: +39 0586 443954
web: www.websynapsis.com
=========================================================================To
unsubscribe: mailto listserv@(protected) with body: "signoff
JSP-INTEREST".
For digest: mailto listserv@(protected) with body: "set JSP-INTEREST
DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com
==========================================================================To
unsubscribe: mailto listserv@(protected) with body: "signoff JSP-INTEREST".
For digest: mailto listserv@(protected) with body: "set JSP-INTEREST DIGEST".
Some relevant archives, FAQs and Forums on JSPs can be found at:
http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com
|
|
