Index: lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java
===================================================================
diff -u -r42ddbd4c509c956cc9f5328cea8d45d6e593e796 -rf69f82e8d1b58cea73df77666229d14cce73cf32
--- lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java	(.../LessonDAO.java)	(revision 42ddbd4c509c956cc9f5328cea8d45d6e593e796)
+++ lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java	(.../LessonDAO.java)	(revision f69f82e8d1b58cea73df77666229d14cce73cf32)
@@ -28,7 +28,7 @@
 	private static final String TABLENAME ="lams_lesson";
 	private final static String FIND_BY_USER="from " + TABLENAME + 
 											 " in class " + Lesson.class.getName() +
-											 " where user_id=?";
+											 " where user_id=? and lesson_state_id <= 6";
     /**
      * Retrieves the Lesson
      * @param lessonId identifies the lesson to get
@@ -57,12 +57,14 @@
              }
        ); 
     }
-    
+  
+    /** Get all the lessons in the database. This includes the disabled lessons. */
     public List getAllLessons()
     {
         return getHibernateTemplate().loadAll(Lesson.class);
     }
-    /**
+    
+     /**
      * Gets all lessons that are active for a learner.
      * @param learner a User that identifies the learner.
      * @return a List with all active lessons in it.