Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dao/hibernate/ScratchieSessionDAOHibernate.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dao/hibernate/ScratchieSessionDAOHibernate.java,v
diff -u -r1.1 -r1.2
--- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dao/hibernate/ScratchieSessionDAOHibernate.java	19 Jul 2012 19:20:08 -0000	1.1
+++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dao/hibernate/ScratchieSessionDAOHibernate.java	16 Nov 2012 08:08:05 -0000	1.2
@@ -33,7 +33,7 @@
     private static final String FIND_BY_SESSION_ID = "from " + ScratchieSession.class.getName()
 	    + " as p where p.sessionId=?";
     private static final String FIND_BY_CONTENT_ID = "from " + ScratchieSession.class.getName()
-	    + " as p where p.scratchie.contentId=?";
+	    + " as p where p.scratchie.contentId=? order by p.sessionName asc";
 
     public ScratchieSession getSessionBySessionId(Long sessionId) {
 	List list = getHibernateTemplate().find(FIND_BY_SESSION_ID, sessionId);