if you wanna share your finally code with me on how you get it to work, I will send you a city & zip database
dave because I can't do it myself:) ----- Original Message ----- From: "John Paul Ashenfelter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 13, 2003 5:44 PM Subject: Re: Postal Code lookup / ZIP Code lookup > David, > > I've done it w/ US zipcodes but should be straightforward for Canada as > well. The prerequisite is that you need a database that maps postal codes to > latitude/longitude values. The US Census produces a free one every 10 years, > and there are plenty of commercial ones. > > The code is all in this article (that I wrote :) > > http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci523000,00.html > > > Regards, > > John Paul Ashenfelter > CTO/Transitionpoint > [EMAIL PROTECTED] > ----- Original Message ----- > From: "David K" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, March 13, 2003 3:38 PM > Subject: SOT: Postal Code lookup / ZIP Code lookup > > > > Hi List: > > > > Client wants a "Dealer Locator" widget that finds a dealer based on a > Postal Code lookup / ZIP Code lookup. User would enter a Postal Code and the > app would return the nearest dealer. > > Here's an example; > > http://www.ford.ca/focudl/default.asp?Language=EN > > > > I'm a bit stumped on the program logic required to do this. For example, > if the user entered T9X-1P4 (an Alberta postal code) and the nearest dealer > is in the V0B-2G0 (A British Columbia postal code) how could this be coded? > > > > Wondering if anyone has had any experience they would be willing to share. > TIA. > > > > --David > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
