Index: openacs-4/packages/acs-admin/www/apm/package-add.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/Attic/package-add.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-admin/www/apm/package-add.xql	27 Apr 2001 01:41:12 -0000	1.1
+++ openacs-4/packages/acs-admin/www/apm/package-add.xql	28 Apr 2001 01:04:25 -0000	1.2
@@ -4,7 +4,7 @@
 <fullquery name="apm_get_name">      
       <querytext>
        
-    select first_names || ' ' || last_name user_name, email from cc_users where user_id = :user_id
+    select first_names || ' ' || last_name as user_name, email from cc_users where user_id = :user_id
 
       </querytext>
 </fullquery>
Index: openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql	27 Apr 2001 17:39:15 -0000	1.12
+++ openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql	28 Apr 2001 01:04:25 -0000	1.13
@@ -2632,7 +2632,7 @@
   version_name           alias for $1;  
   a_start                integer;       
   a_end                  integer;       
-  a_order                varchar(1000); 
+  a_order                varchar(1000) default ''''; 
   a_char                 char(1);       
   a_seen_letter          boolean default ''f'';        
 begin