Index: openacs-4/packages/ecommerce/www/shipping-address-2.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/Attic/shipping-address-2.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ecommerce/www/shipping-address-2.xql	22 Oct 2001 07:38:06 -0000	1.2
+++ openacs-4/packages/ecommerce/www/shipping-address-2.xql	16 Feb 2002 23:32:06 -0000	1.3
@@ -1,29 +1,33 @@
 <?xml version="1.0"?>
 <queryset>
 
-<fullquery name="get_order_id">      
-      <querytext>
+  <fullquery name="get_order_id">      
+    <querytext>
       select order_id from ec_orders where user_session_id=:user_session_id and order_state='in_basket'
-      </querytext>
-</fullquery>
-
+    </querytext>
+  </fullquery>
  
-<fullquery name="insert_new_address">      
-      <querytext>
-      insert into ec_addresses
-    (address_id, user_id, address_type, attn, line1, line2, city, usps_abbrev, zip_code, country_code, phone, phone_time)
-    values
-    (:address_id, :user_id, 'shipping', :attn, :line1,:line2,:city,:usps_abbrev,:zip_code,'US',:phone,:phone_time)
-    
-      </querytext>
-</fullquery>
+  <fullquery name="update_address">      
+    <querytext>
+      update ec_addresses 
+      set attn=:attn, line1=:line1, line2=:line2, city=:city, usps_abbrev=:usps_abbrev, zip_code=:zip_code, phone=:phone, phone_time=:phone_time
+      where address_id=:address_id
+    </querytext>
+  </fullquery>
 
+  <fullquery name="insert_new_address">      
+    <querytext>
+      insert into ec_addresses
+      (address_id, user_id, address_type, attn, line1, line2, city, usps_abbrev, zip_code, country_code, phone, phone_time)
+      values
+      (:address_id, :user_id, 'shipping', :attn, :line1,:line2,:city,:usps_abbrev,:zip_code,'US',:phone,:phone_time)
+    </querytext>
+  </fullquery>
  
-<fullquery name="set_shipping_on_order">      
-      <querytext>
-      update ec_orders set shipping_address=:address_id where order_id=:order_id
-      </querytext>
-</fullquery>
-
+  <fullquery name="set_shipping_on_order">      
+    <querytext>
+    update ec_orders set shipping_address=:address_id where order_id=:order_id
+    </querytext>
+  </fullquery>
  
 </queryset>