Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUsrAttemptDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUsrAttemptDAO.java,v
diff -u -r1.11 -r1.12
--- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUsrAttemptDAO.java	7 Jan 2006 14:13:21 -0000	1.11
+++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dao/hibernate/McUsrAttemptDAO.java	7 Jan 2006 16:10:37 -0000	1.12
@@ -46,6 +46,8 @@
 	 	
 	 	private static final String LOAD_ATTEMPT_FOR_USER		 = "from mcUsrAttempt in class McUsrAttempt where mcUsrAttempt.queUsrId=:queUsrId";
 	 	
+	 	private static final String LOAD_ATTEMPT_FOR_USER_AND_QUESTION_CONTENT	 = "from mcUsrAttempt in class McUsrAttempt where mcUsrAttempt.queUsrId=:queUsrId and mcUsrAttempt.mcQueContentId=:mcQueContentId";
+	 	
 	 	private static final String LOAD_ATTEMPT_BY_ATTEMPT_ORDER = "from mcUsrAttempt in class McUsrAttempt where mcUsrAttempt.queUsrId=:queUsrId and mcUsrAttempt.mcQueContentId=:mcQueContentId and attemptOrder=:attemptOrder";
 	 	
 	 	private static final String LOAD_MARK = "from mcUsrAttempt in class McUsrAttempt";
@@ -101,6 +103,18 @@
 			return list;
 	    }
 		
+		public List getAttemptsForUserAndQuestionContent(final Long queUsrId, final Long mcQueContentId)
+	    {
+	        HibernateTemplate templ = this.getHibernateTemplate();
+	        List list = getSession().createQuery(LOAD_ATTEMPT_FOR_USER_AND_QUESTION_CONTENT)
+			.setLong("queUsrId", queUsrId.longValue())
+			.setLong("mcQueContentId", mcQueContentId.longValue())
+			.list();
+	        
+			return list;
+	    }
+		
+		
 		public List getAttemptForQueContent(final Long queUsrId, final Long mcQueContentId)
 	    {
 	        HibernateTemplate templ = this.getHibernateTemplate();