Index: openacs-4/packages/forums/lib/message/threads-chunk-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/message/Attic/threads-chunk-oracle.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/forums/lib/message/threads-chunk-oracle.xql	4 Dec 2004 03:06:55 -0000	1.1.2.1
+++ openacs-4/packages/forums/lib/message/threads-chunk-oracle.xql	4 Dec 2004 17:54:03 -0000	1.1.2.2
@@ -2,6 +2,24 @@
 <queryset>
     <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
+    <fullquery name="messages_select_paginate">
+        <querytext>
+            select fm.message_id,
+                   fm.subject,
+                   person.name(fm.user_id) as user_name,
+                   to_char(fm.posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi,
+                   (select count(*)
+                    from $replies_view fm1
+                    where fm1.forum_id = :forum_id
+                    and fm1.tree_sortkey between tree.left(fm.tree_sortkey) and tree.right(fm.tree_sortkey)) as n_messages,
+                   to_char(fm.last_child_post, 'YYYY-MM-DD HH24:MI:SS') as last_child_post_ansi
+            from forums_messages_approved fm
+            where fm.forum_id = :forum_id
+            and fm.parent_id is null
+            [template::list::orderby_clause -orderby -name "messages"]
+        </querytext>
+    </fullquery>
+
     <fullquery name="messages_select">
         <querytext>
             select fm.message_id,
Index: openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/message/Attic/threads-chunk-postgresql.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql	4 Dec 2004 03:06:55 -0000	1.1.2.1
+++ openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql	4 Dec 2004 17:54:03 -0000	1.1.2.2
@@ -2,6 +2,23 @@
 <queryset>
     <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
+    <fullquery name="messages_select_paginate">
+        <querytext>
+            select fm.message_id,
+                   fm.subject,
+                   person__name(fm.user_id) as user_name,
+                   (select count(*)
+                    from $replies_view fm1
+                    where fm1.forum_id = :forum_id
+                    and fm1.tree_sortkey between tree_left(fm.tree_sortkey) and tree_right(fm.tree_sortkey)) as n_messages,
+                   to_char(fm.posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi
+            from forums_messages_approved fm
+            where fm.forum_id = :forum_id
+            and fm.parent_id is null
+            [template::list::orderby_clause -orderby -name messages]
+        </querytext>
+    </fullquery>
+
     <fullquery name="messages_select">
         <querytext>
             select fm.message_id,
Fisheye: Tag 1.1.2.2 refers to a dead (removed) revision in file `openacs-4/packages/forums/lib/message/threads-chunk.xql'.
Fisheye: No comparison available.  Pass `N' to diff?