Index: openacs-4/packages/acs-subsite/www/shared/parameters.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/shared/parameters.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/shared/parameters.xql	2 Oct 2003 17:04:08 -0000	1.1
+++ openacs-4/packages/acs-subsite/www/shared/parameters.xql	24 Feb 2010 01:20:15 -0000	1.2
@@ -7,4 +7,37 @@
       and section_name=:section
     </querytext>
   </fullquery>
+
+  <fullquery name="select_params">      
+    <querytext>
+      select p.parameter_name,
+        coalesce(p.description, 'No Description') as description,
+        v.attr_value,
+        coalesce(p.section_name, '') as section_name,
+        p.datatype
+      from apm_parameters p left outer join
+        (select v.parameter_id, v.attr_value
+         from apm_parameter_values v
+         where v.package_id = :package_id) v
+        on p.parameter_id = v.parameter_id
+      where p.package_key = :package_key
+	$section_where_clause
+      order  by section_name, parameter_name
+    </querytext>
+  </fullquery>
+
+  <fullquery name="select_params_set">      
+    <querytext>
+      select p.parameter_name as c__parameter_name
+      from apm_parameters p left outer join
+        (select v.parameter_id, v.attr_value
+         from apm_parameter_values v
+         where v.package_id = :package_id) v
+        on p.parameter_id = v.parameter_id
+      where p.package_key = :package_key
+      $section_where_clause
+    </querytext>
+  </fullquery>
+
 </queryset>
+