Index: openacs-4/packages/curriculum-central/www/coordinate/gradattrs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/www/coordinate/gradattrs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/curriculum-central/www/coordinate/gradattrs-postgresql.xql	6 Jan 2006 05:46:13 -0000	1.2
+++ openacs-4/packages/curriculum-central/www/coordinate/gradattrs-postgresql.xql	12 Jan 2006 07:15:24 -0000	1.3
@@ -5,11 +5,13 @@
 
    <fullquery name="get_gradattrs">
      <querytext>
-       SELECT g.gradattr_id, g.name, g.identifier, g.description, g.level
-       FROM cc_uos_gradattr g, acs_objects o
-	   WHERE package_id = :package_id
+       SELECT g.gradattr_id, n.name,
+           g.identifier, g.description, g.level
+       FROM cc_uos_gradattr g, acs_objects o, cc_uos_gradattr_name n
+	   WHERE n.package_id = :package_id
 	   AND g.gradattr_id = o.object_id
 	   AND o.creation_user = :user_id
+	   AND n.name_id = g.name_id
 	   [template::list::orderby_clause -orderby -name "gradattrs"]
      </querytext>
    </fullquery>