Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentResultDAOHibernate.java =================================================================== diff -u -rfd9592fa74d56ccd0719c7245b3424b3523f2197 -r80abc9d8fb675b692eeed5e3bae46c759c8c317a --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentResultDAOHibernate.java (.../AssessmentResultDAOHibernate.java) (revision fd9592fa74d56ccd0719c7245b3424b3523f2197) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentResultDAOHibernate.java (.../AssessmentResultDAOHibernate.java) (revision 80abc9d8fb675b692eeed5e3bae46c759c8c317a) @@ -160,7 +160,7 @@ FIND_BY_QBQUESTION_AND_FINISHED += "AND REGEXP_REPLACE(q.answer, '" + AssessmentEscapeUtils.VSA_ANSWER_NORMALISE_SQL_REG_EXP + "', '') = :answer"; } - FIND_BY_QBQUESTION_AND_FINISHED += "ORDER BY r.startDate ASC"; + FIND_BY_QBQUESTION_AND_FINISHED += " ORDER BY r.startDate ASC"; Query q = getSession().createQuery(FIND_BY_QBQUESTION_AND_FINISHED, AssessmentResult.class); q.setParameter("qbQuestionUid", qbQuestionUid);