Index: openacs-4/packages/forums/tcl/forums-callback-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/forums-callback-procs-oracle.xql,v diff -u -N -r1.1 -r1.1.2.1 --- openacs-4/packages/forums/tcl/forums-callback-procs-oracle.xql 28 Jan 2006 15:39:03 -0000 1.1 +++ openacs-4/packages/forums/tcl/forums-callback-procs-oracle.xql 26 Jun 2007 07:53:13 -0000 1.1.2.1 @@ -35,9 +35,8 @@ select subject, content, format from forums_messages - where message_id=:message_id --- lets just get the message instead of the whole thread --- replace with a connect by + start with message_id=:message_id + connect by prior message_id = parent_id Index: openacs-4/packages/forums/tcl/forums-callback-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/forums-callback-procs-postgresql.xql,v diff -u -N -r1.1 -r1.1.2.1 --- openacs-4/packages/forums/tcl/forums-callback-procs-postgresql.xql 28 Jan 2006 15:39:03 -0000 1.1 +++ openacs-4/packages/forums/tcl/forums-callback-procs-postgresql.xql 26 Jun 2007 07:53:13 -0000 1.1.2.1 @@ -35,9 +35,9 @@ select subject, content, format from forums_messages - where message_id=:message_id --- lets just get the message instead of the whole thread --- replace with a connect by + where message_id=:message_id or (tree_sortkey between tree_left(:tree_sortkey) and tree_right(:tree_sortkey)) + and forum_id=:forum_id + order by tree_sortkey