Index: openacs-4/packages/ecommerce/www/admin/orders/address-add-3.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/address-add-3.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/orders/address-add-3.xql	10 Jul 2001 20:33:53 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/orders/address-add-3.xql	26 May 2002 04:36:50 -0000	1.2
@@ -1,29 +1,37 @@
 <?xml version="1.0"?>
 <queryset>
 
-<fullquery name="user_id_select">      
-      <querytext>
-      select user_id from ec_orders where order_id=:order_id
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="address_insert">      
-      <querytext>
+  <fullquery name="user_id_select">      
+    <querytext>
+      select user_id
+      from ec_orders
+      where order_id = :order_id
+    </querytext>
+  </fullquery>
+  
+  <fullquery name="address_insert">      
+    <querytext>
       insert into ec_addresses
-  (address_id, user_id, address_type, attn, line1, line2, city, usps_abbrev, full_state_name, zip_code, country_code, phone, phone_time)
-  values
-  (:address_id, :user_id, 'shipping', :attn, :line1, :line2, :city, :usps_abbrev, :full_state_name, :zip_code, :country_code, :phone, :phone_time)
+      (address_id, user_id, address_type, attn, line1, line2, city, usps_abbrev, full_state_name, zip_code, country_code, phone, phone_time)
+      values
+      (:address_id, :user_id, 'shipping', :attn, :line1, :line2, :city, :usps_abbrev, :full_state_name, :zip_code, :country_code, :phone, :phone_time)
+    </querytext>
+  </fullquery>
   
-      </querytext>
-</fullquery>
+  <fullquery name="ec_orders_update">      
+    <querytext>
+      update ec_orders
+      set shipping_address = :address_id
+      where order_id = :order_id
+    </querytext>
+  </fullquery>
+  
+  <fullquery name="ec_orders_update">      
+    <querytext>
+      update ec_creditcards
+      set billing_address = :address_id
+      where creditcard_id = :creditcard_id
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="ec_orders_update">      
-      <querytext>
-      update ec_orders set shipping_address=:address_id where order_id=:order_id
-      </querytext>
-</fullquery>
-
- 
 </queryset>