Index: openacs-4/packages/ecommerce/www/address-international.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/address-international.xql,v
diff -u -r1.1 -r1.1.8.1
--- openacs-4/packages/ecommerce/www/address-international.xql	26 May 2002 05:09:57 -0000	1.1
+++ openacs-4/packages/ecommerce/www/address-international.xql	23 Dec 2004 13:24:49 -0000	1.1.8.1
@@ -4,10 +4,26 @@
 
   <fullquery name="get_full_name">      
     <querytext>
-      select first_names || ' ' || last_name as name 
+      select first_names || '   ' || last_name as name 
       from cc_users
       where user_id=:user_id
     </querytext>
   </fullquery>
 
+  <fullquery name="get_names">      
+    <querytext>
+      select first_names, last_name 
+      from cc_users
+      where user_id=:user_id
+    </querytext>
+  </fullquery>
+
+  <fullquery name="select_address">      
+    <querytext>
+      select attn, line1, line2, city, usps_abbrev, zip_code, phone, country_code, full_state_name, phone_time 
+      from ec_addresses
+      where address_id=:address_id
+    </querytext>
+  </fullquery>
+
 </queryset>