Index: openacs-4/packages/ams/tcl/ams-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/tcl/ams-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ams/tcl/ams-procs-postgresql.xql	20 Oct 2004 21:40:03 -0000	1.1
+++ openacs-4/packages/ams/tcl/ams-procs-postgresql.xql	21 Oct 2004 01:53:49 -0000	1.2
@@ -1,6 +1,15 @@
 <?xml version="1.0"?>
 <queryset>
 
+<fullquery name="ams::ad_form::elements.select_elements">
+  <querytext>
+        select ams_attribute_id, required_p
+          from ams_list_attribute_map
+         where list_id = :list_id
+         order by sort_order
+  </querytext>
+</fullquery>
+
 <fullquery name="ams_object_id_not_cached.select_ams_object_id">
   <querytext>
         select ams_object_id(:object_id)
@@ -248,7 +257,7 @@
   </querytext>
 </fullquery>
 
-<fullquery name="ams::list::ams_attribute_ids_not_cached">
+<fullquery name="ams::list::ams_attribute_ids_not_cached.ams_attribute_ids">
   <querytext>
         select ams_attribute_id
           from ams_list_attribute_map
@@ -271,7 +280,7 @@
   <querytext>
         select list_id
           from ams_lists
-         where short_name = :short_name
+         where short_name = :list_name
            and package_key = :package_key
            and object_type = :object_type
   </querytext>