Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardAttachmentDAO.java
===================================================================
diff -u -r1cbe15aa8f21cd0c2f0b3d871f5a73265a1bd56e -rb06501f351ba3b41056626a7214905cb00f80ad9
--- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardAttachmentDAO.java	(.../NoticeboardAttachmentDAO.java)	(revision 1cbe15aa8f21cd0c2f0b3d871f5a73265a1bd56e)
+++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dao/hibernate/NoticeboardAttachmentDAO.java	(.../NoticeboardAttachmentDAO.java)	(revision b06501f351ba3b41056626a7214905cb00f80ad9)
@@ -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)
     {