Index: openacs-4/packages/acs-subsite/www/shared/parameters-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/shared/Attic/parameters-oracle.xql,v diff -u -r1.2 -r1.2.12.1 --- openacs-4/packages/acs-subsite/www/shared/parameters-oracle.xql 2 Oct 2003 17:04:08 -0000 1.2 +++ openacs-4/packages/acs-subsite/www/shared/parameters-oracle.xql 26 May 2007 12:19:02 -0000 1.2.12.1 @@ -9,7 +9,8 @@ select p.parameter_name, nvl(p.description, 'No Description') as description, v.attr_value, - nvl(p.section_name, '') as section_name + nvl(p.section_name, '') as section_name, + p.datatype from apm_parameters p, (select v.parameter_id, v.attr_value Index: openacs-4/packages/acs-subsite/www/shared/parameters-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/shared/Attic/parameters-postgresql.xql,v diff -u -r1.2 -r1.2.12.1 --- openacs-4/packages/acs-subsite/www/shared/parameters-postgresql.xql 2 Oct 2003 17:04:08 -0000 1.2 +++ openacs-4/packages/acs-subsite/www/shared/parameters-postgresql.xql 26 May 2007 12:19:02 -0000 1.2.12.1 @@ -9,7 +9,8 @@ select p.parameter_name, coalesce(p.description, 'No Description') as description, v.attr_value, - coalesce(p.section_name, '') as section_name + coalesce(p.section_name, '') as section_name, + p.datatype from apm_parameters p left outer join (select v.parameter_id, v.attr_value