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
