Index: openacs-4/packages/dotlrn/www/manage-memberships-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/Attic/manage-memberships-oracle.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/dotlrn/www/manage-memberships-oracle.xql	12 Apr 2002 08:32:11 -0000	1.6
+++ openacs-4/packages/dotlrn/www/manage-memberships-oracle.xql	30 May 2002 02:57:34 -0000	1.7
@@ -17,6 +17,7 @@
         <querytext>
             select dotlrn_class_instances_full.*,
                    dotlrn_member_rels_full.role,
+                   dotlrn_member_rels_full.rel_type,
                    dotlrn_member_rels_full.member_state,
                    acs_permission.permission_p(dotlrn_class_instances_full.class_instance_id, :user_id, 'admin') as admin_p
             from dotlrn_class_instances_full,
@@ -32,6 +33,7 @@
         <querytext>
             select dotlrn_class_instances_full.*,
                    dotlrn_member_rels_full.role,
+                   dotlrn_member_rels_full.rel_type,
                    dotlrn_member_rels_full.member_state,
                    acs_permission.permission_p(dotlrn_class_instances_full.class_instance_id, :user_id, 'admin') as admin_p
             from dotlrn_class_instances_full,
@@ -48,6 +50,7 @@
         <querytext>
             select dotlrn_class_instances_full.*,
                    dotlrn_member_rels_full.role,
+                   dotlrn_member_rels_full.rel_type,
                    dotlrn_member_rels_full.member_state,
                    acs_permission.permission_p(dotlrn_class_instances_full.class_instance_id, :user_id, 'admin') as admin_p
             from dotlrn_class_instances_full,
@@ -64,6 +67,7 @@
         <querytext>
             select dotlrn_class_instances_full.*,
                    dotlrn_member_rels_full.role,
+                   dotlrn_member_rels_full.rel_type,
                    dotlrn_member_rels_full.member_state,
                    acs_permission.permission_p(dotlrn_class_instances_full.class_instance_id, :user_id, 'admin') as admin_p
             from dotlrn_class_instances_full,
@@ -81,6 +85,7 @@
         <querytext>
             select dotlrn_clubs_full.*,
                    dotlrn_member_rels_full.role,
+                   dotlrn_member_rels_full.rel_type,
                    dotlrn_member_rels_full.member_state,
                    acs_permission.permission_p(dotlrn_clubs_full.club_id, :user_id, 'admin') as admin_p
             from dotlrn_clubs_full,