Yeah, that explains on one dating site I was looking at, I did a 50 mile radius search and I was getting people from Stockton, which is WAY more than 50 miles from where I live. I will do the geocode deal. I use Google for our school district site for school boundaries. Pretty slick API that they have.
Thanks, Bruce -----Original Message----- From: Dave l [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 21, 2007 7:11 PM To: CF-Talk Subject: Re: Zip Code Locator 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:293673 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
