Index: openacs-4/packages/ecommerce/www/checkout.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/checkout.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/checkout.xql	10 Jul 2001 20:42:02 -0000	1.1
+++ openacs-4/packages/ecommerce/www/checkout.xql	26 May 2002 04:36:50 -0000	1.2
@@ -1,35 +1,31 @@
 <?xml version="1.0"?>
+
 <queryset>
 
-<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>
+  <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>
 
- 
-<fullquery name="update_ec_order_set_uid">      
-      <querytext>
-      update ec_orders set user_id=:user_id where order_id=:order_id
-      </querytext>
-</fullquery>
+  <fullquery name="update_ec_order_set_uid">      
+    <querytext>
+      update ec_orders
+      set user_id=:user_id
+      where order_id=:order_id
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="get_user_addresses">      
-      <querytext>
-      
-select address_id, attn,
-       line1,
-       line2,
-       city, usps_abbrev, zip_code,
-       phone, country_code, full_state_name,
-       phone_time
-  from ec_addresses
- where user_id=:user_id
-   and address_type='shipping'
+  <fullquery name="get_user_addresses">      
+    <querytext>
+      select address_id, attn, line1, line2, city, usps_abbrev, zip_code, phone, country_code, full_state_name, phone_time
+      from ec_addresses
+      where user_id=:user_id
+      and address_type='shipping'
+    </querytext>
+  </fullquery>
 
-      </querytext>
-</fullquery>
-
- 
 </queryset>