Index: openacs-4/packages/ams/tcl/ams-widget-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/tcl/ams-widget-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ams/tcl/ams-widget-procs-postgresql.xql	18 May 2005 17:11:48 -0000	1.1
+++ openacs-4/packages/ams/tcl/ams-widget-procs-postgresql.xql	9 Sep 2005 14:06:12 -0000	1.2
@@ -4,9 +4,11 @@
 <fullquery name="ams::widget_options.get_options">
   <querytext>
     select option,
-           option_id
-      from ams_option_types
+           option_id,
+	   title as pretty_name
+      from ams_option_types aot, acs_objects ao
      where attribute_id = :attribute_id
+	and aot.option_id = ao.object_id
        and not deprecated_p
      order by sort_order
   </querytext>