you don't need that and its not accurate, just do a geocode on address and then the formula.
The reason why using a zipcodes lat and lon don't work is because lets say person a is in zipcode 1 and zipcode 1 is 40 square miles and they live on the outer western edge and person 2 is in zipcode 2 which is 20 square miles and which is directly next to zipcode one and they live near eastern side. If you run the codes based on the zipcode lat and lon they will be approx 30 miles apart but if you run it on actual lat and lon they might only be a mile apart. Why is this? The zipcode lat and lon are based on the center of the the zipcode not the actual locations. >We use this: >http://www.zipcodedownload.com/Products/Product/Z5Premium/Standard/Overview/ > >Using the latitude and longitude you can calculate distances between zip >codes. > >Russ > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293672 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
