Index: openacs-4/packages/ecommerce/www/shopping-cart.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/shopping-cart.xql,v
diff -u -r1.5 -r1.5.8.1
--- openacs-4/packages/ecommerce/www/shopping-cart.xql	19 Sep 2002 03:24:55 -0000	1.5
+++ openacs-4/packages/ecommerce/www/shopping-cart.xql	9 Mar 2005 06:02:26 -0000	1.5.8.1
@@ -11,6 +11,24 @@
     </querytext>
   </fullquery>
 
+
+  <fullquery name="get_shipping_address_ids">
+    <querytext>
+      select address_id
+      from ec_addresses
+      where user_id=:user_id
+      and address_type = 'shipping'
+    </querytext>
+  </fullquery>
+
+  <fullquery name="select_shipping_area">
+    <querytext>
+      select country_code, zip_code 
+      from ec_addresses
+      where address_id = :shipping_address_id
+    </querytext>
+  </fullquery>
+
   <fullquery name="tax_states">      
     <querytext>
       select tax_rate, initcap(state_name) as state