Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardAttachmentDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/Attic/NoticeboardAttachmentDAO.java,v
diff -u -r1.1 -r1.2
--- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardAttachmentDAO.java	29 Jul 2005 04:27:33 -0000	1.1
+++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardAttachmentDAO.java	2 Aug 2005 06:30:23 -0000	1.2
@@ -41,6 +41,21 @@
         }
     }
     
+    public NoticeboardAttachment retrieveAttachmentByFilename(String filename)
+    {
+        String query= "from NoticeboardAttachment na where na.filename=?";
+        List attachments = getHibernateTemplate().find(query,filename);
+        if (attachments!= null && attachments.size() == 0)
+        {
+            return null;
+        }
+        else
+        {
+            return (NoticeboardAttachment)attachments.get(0);
+        }
+    }
+    
+    
     /* get the list of attachment ids which have the toolcontentid equals to that of nbCotnetn.getNbContentId */
     public List getAttachmentIdsFromContent(NoticeboardContent nbContent)
     {