Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentResultDAOHibernate.java =================================================================== diff -u -re194f22014c7cbffaf5168f1982aa89e7c34c34d -r8a1b895ac8bd80a6808e80079f422a04664633f4 --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentResultDAOHibernate.java (.../AssessmentResultDAOHibernate.java) (revision e194f22014c7cbffaf5168f1982aa89e7c34c34d) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dao/hibernate/AssessmentResultDAOHibernate.java (.../AssessmentResultDAOHibernate.java) (revision 8a1b895ac8bd80a6808e80079f422a04664633f4) @@ -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);