Index: openacs-4/packages/dotlrn-catalog/lib/course-chunk.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-catalog/lib/course-chunk.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/dotlrn-catalog/lib/course-chunk.xql	16 Feb 2005 00:22:12 -0000	1.2
+++ openacs-4/packages/dotlrn-catalog/lib/course-chunk.xql	19 Feb 2005 02:32:07 -0000	1.3
@@ -16,8 +16,23 @@
     <fullquery name="relation">
         <querytext>
             select object_id_two as object_id, rel_type as type from acs_rels
-	    where object_id_one = :course_id order by type
+	    where object_id_one = :course_id  order by type 
         </querytext>
     </fullquery>
 
+  <fullquery name="get_dotlrn_classes">
+        <querytext>
+            select class_instance_id as object_id, department_name, term_name, class_name, pretty_name, url
+            from dotlrn_class_instances_full where class_instance_id in $dotlrn_class
+            order by department_name, term_name, class_name, pretty_name
+        </querytext>
+    </fullquery>
+
+    <fullquery name="get_dotlrn_communities">
+        <querytext>
+            select community_id as object_id, pretty_name, url from dotlrn_clubs_full 
+	    where community_id in $dotlrn_com order by pretty_name
+        </querytext>
+    </fullquery>
+
 </queryset>
\ No newline at end of file