Index: openacs-4/packages/ecommerce/tcl/ecommerce-utilities-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-utilities-procs.tcl,v
diff -u -r1.13 -r1.13.2.1
--- openacs-4/packages/ecommerce/tcl/ecommerce-utilities-procs.tcl	8 Mar 2004 19:46:11 -0000	1.13
+++ openacs-4/packages/ecommerce/tcl/ecommerce-utilities-procs.tcl	29 Oct 2004 04:45:45 -0000	1.13.2.1
@@ -608,9 +608,12 @@
 
 } {
     set sql "
-    	select state_code, city_name, county_name
-      	from zip_codes
-     	where zip_code=:zip_code"
+        select s.abbrev as state_code, z.name as city_name, c.name as county_name
+        from us_zipcodes z, us_states s, us_counties c
+        where  z.fips_state_code = s.fips_state_code and
+            z.fips_county_code = c.fips_county_code and
+            z.fips_state_code = c.fips_state_code and
+            z.zipcode=:zip_code"    
     
     set city_list [list]
     if { [catch {