Index: openacs-4/packages/forums/tcl/forums-callback-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/Attic/forums-callback-procs-oracle.xql,v
diff -u -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/Attic/forums-callback-procs-postgresql.xql,v
diff -u -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