Index: openacs.org-dev/packages/forums/www/forum-view-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/forums/www/forum-view-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs.org-dev/packages/forums/www/forum-view-oracle.xql	9 Aug 2002 18:11:22 -0000	1.2
+++ openacs.org-dev/packages/forums/www/forum-view-oracle.xql	5 Sep 2002 17:27:48 -0000	1.3
@@ -11,12 +11,12 @@
                    fm.posting_date,
                    fm.state,
                    (select count(*)
-                    from $forums_table fm1
+                    from forums_messages_approved 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(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified,
                    case when acs_objects.last_modified > (sysdate - 1) then 't' else 'f' end as new_p                   
-            from $forums_table fm,
+            from forums_messages_approved fm,
                  acs_objects
             where fm.forum_id = :forum_id
             and fm.parent_id is null
@@ -25,7 +25,7 @@
         </querytext>
     </fullquery>
 
-    <partialquery name="display_partial_data">
+    <fullquery name="messages_select_moderator">
         <querytext>
             select fm.message_id,
                    fm.subject,
@@ -34,19 +34,18 @@
                    fm.posting_date,
                    fm.state,
                    (select count(*)
-                    from $forums_table fm1
+                    from forums_messages 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(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified,
                    case when acs_objects.last_modified > (sysdate - 1) then 't' else 'f' end as new_p                   
-            from $forums_table fm,
+            from forums_messages fm,
                  acs_objects
             where fm.forum_id = :forum_id
             and fm.parent_id is null
             and fm.message_id = acs_objects.object_id
-            and fm.message_id IN (CURRENT_PAGE_SET)
             order by fm.posting_date desc
         </querytext>
-    </partialquery>
+    </fullquery>
 
 </queryset>