Index: lams_admin/web/usersearchlist.jsp
===================================================================
RCS file: /usr/local/cvsroot/lams_admin/web/usersearchlist.jsp,v
diff -u -r1.30 -r1.31
--- lams_admin/web/usersearchlist.jsp	8 Feb 2016 20:42:07 -0000	1.30
+++ lams_admin/web/usersearchlist.jsp	30 Aug 2016 06:54:14 -0000	1.31
@@ -149,7 +149,7 @@
 <table id="tablesorter">
 	<thead>
 		<tr>
-			<th width="3%" clas="{sorter: 'digit'}">
+			<th width="3%">
 				<fmt:message key="admin.user.userid"/>
 			</th>
 			<th width="15%" align="center">
Index: lams_common/src/java/org/lamsfoundation/lams/usermanagement/dao/hibernate/UserDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/usermanagement/dao/hibernate/UserDAO.java,v
diff -u -r1.9 -r1.10
--- lams_common/src/java/org/lamsfoundation/lams/usermanagement/dao/hibernate/UserDAO.java	5 May 2016 08:11:41 -0000	1.9
+++ lams_common/src/java/org/lamsfoundation/lams/usermanagement/dao/hibernate/UserDAO.java	30 Aug 2016 06:54:22 -0000	1.10
@@ -24,13 +24,25 @@
 	// support for custom search from a toolbar
 	GET_USERS = addNameSearch(GET_USERS, searchString);
 	//order by
-	GET_USERS += " ORDER BY CASE " + " WHEN :sortBy='userId' THEN user.userId "
-		+ " WHEN :sortBy='login' THEN user.login " + " WHEN :sortBy='firstName' THEN user.firstName "
-		+ " WHEN :sortBy='lastName' THEN user.lastName " + " WHEN :sortBy='email' THEN user.email " + " END "
-		+ sortOrder;
+	if ("userId".equals(sortBy)) {
+	    sortBy = "user.userId + 0";
 
+	} else if ("login".equals(sortBy)) {
+	    sortBy = "user.login";
+
+	} else if ("firstName".equals(sortBy)) {
+	    sortBy = "user.firstName";
+
+	} else if ("lastName".equals(sortBy)) {
+	    sortBy = "user.lastName";
+
+	} else if ("email".equals(sortBy)) {
+	    sortBy = "user.email";
+
+	}
+	GET_USERS += " ORDER BY " + sortBy + " " + sortOrder;
+
 	Query query = getSession().createQuery(GET_USERS);
-	query.setString("sortBy", sortBy);
 	query.setFirstResult(page * size);
 	query.setMaxResults(size);
 	List<Object[]> list = query.list();