In the past, we have purchased a database of ZIP codes from the United States Postal Service, which included the latitude and longitude for each ZIP code epicentre. Using this information, we could calculate the distance between a given ZIP code epicentre's latitude and longitude, and the latitude and longitutde of the dealer location.
Here is a link to the ZIP Code Directories from the USPS: http://www.usps.com/ncsc/addressinfo/zipcodedirectories.htm If you are interested, I can dig up some example code and post it. HTH -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel > 213.244.5205 Email > [EMAIL PROTECTED] "Hello Stupid, and welcome to your crappy computer." - Strong Bad, HomestarRunner.com > -----Original Message----- > From: Alex Aguilar [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 5:36 AM > To: CF-Talk > Subject: Zipcode finder > > > Does anyone of a zipcode finder application? > > Client wants it so that when user enters zipcode that the > results contain > listings within 50 miles of that zipcode. > I'm looking for an app that will run on windows platfrom (I'd > like it if it > were written in CFML but I'll take asp if it works). The > database we're > running is SQLserver and I've heard there's some stored > procedure apps that > can do this also. > > If anyone can provide me with some good leads I'd really > appreciate it. If > there's a good existing application I can buy then I'm all > for it cause > personally I'm not looking forward to learning the internaly > workings of US > zipcodes. > > Thanks!, > Alex > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
