Index: openacs-4/contrib/packages/resource-list/www/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/resource-list/www/one-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/resource-list/www/one-postgresql.xql	30 Nov 2003 02:15:48 -0000	1.1
+++ openacs-4/contrib/packages/resource-list/www/one-postgresql.xql	24 Dec 2003 06:41:46 -0000	1.2
@@ -44,7 +44,7 @@
   <fullquery name="get_categories">
     <querytext>
       select
-        short_name
+        short_name, c.category_id
         FROM
         rl_resource_category c,
         rl_resource_category_map m,
@@ -53,6 +53,8 @@
         m.resource_item_id = r.item_id and
         c.category_id = m.category_id and
         r.revision_id = $res(resource_revision_id)
+        ORDER BY
+        short_name
     </querytext>
   </fullquery>
 
Index: openacs-4/contrib/packages/resource-list/www/one.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/resource-list/www/one.adp,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/resource-list/www/one.adp	30 Nov 2003 02:15:48 -0000	1.1
+++ openacs-4/contrib/packages/resource-list/www/one.adp	24 Dec 2003 06:41:46 -0000	1.2
@@ -27,7 +27,7 @@
 <font size="-1">Categories:</font>
 <ul>
 <multiple name="cats">
-<LI>@cats.short_name@
+<LI><a href="index?category=@cats.category_id@">@cats.short_name@</a>
 </multiple>
 </ul>