Index: openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.tcl,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.tcl	22 Oct 2001 06:34:04 -0000	1.6
+++ openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs.tcl	22 Oct 2001 07:12:13 -0000	1.7
@@ -178,7 +178,7 @@
     set sql "select * from us_states order by state_name"
     db_foreach get_all_states $sql {
         
-        if { [lsearch $default_list $usps_abbrev] != -1 } {
+        if { [lsearch $default_list $abbrev] != -1 } {
             append widget_value "<option value=\"$abbrev\" SELECTED>$state_name</option>\n" 
         } else {            
             append widget_value "<option value=\"$abbrev\">$state_name</option>\n"
Index: openacs-4/packages/ecommerce/www/admin/sales-tax/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/sales-tax/index.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/sales-tax/index.tcl	20 Apr 2001 20:51:14 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/sales-tax/index.tcl	22 Oct 2001 07:11:55 -0000	1.2
@@ -31,8 +31,8 @@
 
 
 db_foreach get_sales_taxes "select state_name, tax_rate*100 as tax_rate_in_percent, decode(shipping_p,'t','Yes','No') as shipping_p
-from ec_sales_tax_by_state, states
-where ec_sales_tax_by_state.usps_abbrev = states.usps_abbrev" {
+from ec_sales_tax_by_state, us_states
+where ec_sales_tax_by_state.usps_abbrev = us_states.abbrev" {
 
     append page_html "<li>$state_name:
     <blockquote>
Index: openacs-4/packages/ecommerce/www/admin/sales-tax/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/sales-tax/index.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/sales-tax/index.xql	10 Jul 2001 20:33:53 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/sales-tax/index.xql	22 Oct 2001 07:11:55 -0000	1.2
@@ -4,8 +4,8 @@
 <fullquery name="get_sales_taxes">      
       <querytext>
       select state_name, tax_rate*100 as tax_rate_in_percent, case when shipping_p = 't' then 'Yes' else 'No' end as shipping_p
-from ec_sales_tax_by_state, states
-where ec_sales_tax_by_state.usps_abbrev = states.usps_abbrev
+from ec_sales_tax_by_state, us_states
+where ec_sales_tax_by_state.usps_abbrev = us_states.abbrev
       </querytext>
 </fullquery>