Problem with reverse sort...

[garfield11]

Hi all,

Can anyone pls help me with this:

I got this codes "orderby" whereby when user clicks User Name (header) it will order by user name ASC.

Title: View Users

User Name (header) <-- when click, oderby
ABC
DEF
GH


Eh how can i reverse sort, means i clicks once, orderby ASC, click again, orderby DESC...

<%
String orderby= request.getParameter(&quot;orderby&quot;

PreparedStatement stmt = conn.prepareStatement(&quot;Select * from users, department, userGroup where users.deptID = department.deptID and users.userGroupID = userGroup.userGroupID order by ?&quot;
stmt.setString(1, orderby);
ResultSet rs=stmt.executeQuery();
%>

<a href=&quot;viewUser.jsp?orderby=userName&quot;>User Name</a>

Thanks.

 

[palbano]

Well you have to track the &quot;state&quot; of the sort order yes? The two most common methods used to track state is to use the Session object or to use a hidden form variable. Pick one and there is your solution.

-pete