Index: openacs-4/packages/ecommerce/www/shopping-cart-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/shopping-cart-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/www/shopping-cart-oracle.xql 19 Sep 2002 03:24:55 -0000 1.3
+++ openacs-4/packages/ecommerce/www/shopping-cart-oracle.xql 10 Aug 2008 19:56:32 -0000 1.4
@@ -19,4 +19,16 @@
+
+
+ select nvl(base_shipping_cost,0) as base_shipping_cost,
+ nvl(default_shipping_per_item,0) as default_shipping_per_item,
+ nvl(weight_shipping_cost,0) as weight_shipping_cost,
+ nvl(add_exp_base_shipping_cost,0) as add_exp_base_shipping_cost,
+ nvl(add_exp_amount_per_item,0) as add_exp_amount_per_item,
+ nvl(add_exp_amount_by_weight,0) as add_exp_amount_by_weight
+ from ec_admin_settings"
+
+
+
Index: openacs-4/packages/ecommerce/www/shopping-cart-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/shopping-cart-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/www/shopping-cart-postgresql.xql 19 Sep 2002 03:24:55 -0000 1.3
+++ openacs-4/packages/ecommerce/www/shopping-cart-postgresql.xql 10 Aug 2008 19:56:32 -0000 1.4
@@ -21,4 +21,16 @@
+
+
+ select coalesce(base_shipping_cost,0) as base_shipping_cost,
+ coalesce(default_shipping_per_item,0) as default_shipping_per_item,
+ coalesce(weight_shipping_cost,0) as weight_shipping_cost,
+ coalesce(add_exp_base_shipping_cost,0) as add_exp_base_shipping_cost,
+ coalesce(add_exp_amount_per_item,0) as add_exp_amount_per_item,
+ coalesce(add_exp_amount_by_weight,0) as add_exp_amount_by_weight
+ from ec_admin_settings"
+
+
+