Index: lams_tool_forum/.classpath
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_forum/.classpath,v
diff -u -r1.6 -r1.7
--- lams_tool_forum/.classpath 2 Dec 2005 04:58:00 -0000 1.6
+++ lams_tool_forum/.classpath 7 Dec 2005 04:00:24 -0000 1.7
@@ -4,7 +4,7 @@
-
+
Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java,v
diff -u -r1.13 -r1.14
--- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java 5 Dec 2005 03:53:48 -0000 1.13
+++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/persistence/MessageDao.java 7 Dec 2005 04:00:24 -0000 1.14
@@ -14,8 +14,8 @@
* @author conradb
*/
public class MessageDao extends HibernateDaoSupport {
- private static final String SQL_QUERY_FIND_ROOT_TOPICS = "from " + Message.class.getName()
- + " where parent_uid is null and forum_session_uid=?";
+ private static final String SQL_QUERY_FIND_ROOT_TOPICS = "from " + Message.class.getName() +" m "
+ + " where parent_uid is null and m.toolSession.sessionId=?";
private static final String SQL_QUERY_FIND_TOPICS_FROM_AUTHOR = "from " + Message.class.getName()
+ " where is_authored = true and forum_uid=?";
@@ -24,7 +24,7 @@
+ " where parent=?";
private static final String SQL_QUERY_BY_USER_SESSION = "from " + Message.class.getName() + " m "
- + " where m.createdBy.uid = ? and m.toolSession.uid=?";
+ + " where m.createdBy.uid = ? and m.toolSession.sessionId=?";
private static final String SQL_QUERY_BY_SESSION = "from " + Message.class.getName() + " m "
+ " where m.toolSession.sessionId=?";
@@ -70,8 +70,8 @@
public List getRootTopics(Long sessionId) {
return this.getHibernateTemplate().find(SQL_QUERY_FIND_ROOT_TOPICS, sessionId);
}
- public List getTopicsFromAuthor(Long forumId) {
- return this.getHibernateTemplate().find(SQL_QUERY_FIND_TOPICS_FROM_AUTHOR, forumId);
+ public List getTopicsFromAuthor(Long forumUid) {
+ return this.getHibernateTemplate().find(SQL_QUERY_FIND_TOPICS_FROM_AUTHOR, forumUid);
}
public void deleteById(Long uid) {