Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardSessionDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardSessionDAO.java,v
diff -u -r1.4 -r1.5
--- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardSessionDAO.java	14 Jul 2005 02:20:25 -0000	1.4
+++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardSessionDAO.java	21 Jul 2005 04:34:51 -0000	1.5
@@ -23,6 +23,7 @@
 
 import java.util.List;
 import org.lamsfoundation.lams.tool.noticeboard.NoticeboardSession;
+import org.lamsfoundation.lams.tool.noticeboard.NoticeboardContent;
 import org.lamsfoundation.lams.tool.noticeboard.NoticeboardUser;
 import org.lamsfoundation.lams.tool.noticeboard.dao.INoticeboardSessionDAO;
 import org.springframework.orm.hibernate.support.HibernateDaoSupport;
@@ -40,6 +41,10 @@
 	
     private static final String LOAD_NBSESSION_BY_USER = "select ns from NoticeboardSession ns left join fetch "
         + "ns.nbUsers user where user.userId=:userId";
+    
+    private static final String GET_SESSIONS_FROM_CONTENT = "select ns.nbSessionId from NoticeboardSession ns where ns.nbContent= :nbContent";
+    
+    
 
     
     /**
@@ -188,5 +193,12 @@
 	    this.getHibernateTemplate().saveOrUpdate(user);
 	    this.getHibernateTemplate().saveOrUpdateCopy(session);	    
 	}
+	
+	public List getSessionsFromContent(NoticeboardContent nbContent)
+	{
+	    return (getHibernateTemplate().findByNamedParam(GET_SESSIONS_FROM_CONTENT,
+	            "nbContent",
+				nbContent));
+	}
     	
 }