Okay, I couldn't find the code hanging around on my machine, but I remembered the name was zipfinder.cfc and it's pretty nifty. I did a google for it and found the original code<http://www.webmonkey.com/webmonkey/05/32/index4a_page7.html?tw=programming>(click on the 'sample code' link to download).
If you read the entire article (only part of which I've linked to above) you'll learn more than you ever wanted to know about zip code proximity searches. This CFC provides you with three different methods of finding the zip codes (really you're finding longitude/latitude coordinates) in proximity to some other zip code (long/lat coordinate). He discusses the pros and cons of each in his article. Mostly, the issues are speed versus accuracy. If I'm not mistaken, the download that I've pointed you to comes with a zip code database for you to use, but if not, there are several free ones. I started a discussion a year or more ago on this very subject when I was in your shoes, and there were lots of suggestions. In the end I ended up purchasing a "professional" one for about thirty-bucks, but later I found out that I could have gotten one free and I think another person mentioned one that he found for five-bucks. My main concern was completeness of data, and I rationalized that if I bought the thing from some company and there turned out to be some incompleteness, then I had someone to complain to... but really, I'd already spent the money. :o) Good luck, and let us know if you have questions. Like I said, this topic has come up on this list before so there's definitely folks here who can help. Of course you can search for previous discussions, but I'm not going to tell you that you have to (I hate when people tell me to do that...) :o) Chris On Feb 18, 2008 4:44 PM, Chris Jordan <[EMAIL PROTECTED]> wrote: > Iv'e got a CFC that some guy wrote which does all this stuff for you. > Gimme a little bit to dig around for it, and I'll pass it on. > > Chris > > > On Feb 18, 2008 4:14 PM, Bryan Stevenson <[EMAIL PROTECTED]> > wrote: > > > Hey All, > > > > It's been about 6-7 years since I had to do one of these and I'm sure > > (or hope) the options have increased since then. > > > > My last time involved postal code data with lat/long values. An > > equation was run to get all lat/longs inside the search radius and then > > you could grab all your records with postal cods that matched thse lat6 > > longs (or something along these lines). > > > > So what are folks using now? web services? some Google/MS API? other? > > > > I'm mainly interested in Canada and the US at this point > > > > TIA > > > > Cheers > > > > -- > > > > Bryan Stevenson B.Comm. > > VP & Director of E-Commerce Development > > Electric Edge Systems Group Inc. > > phone: 250.480.0642 > > fax: 250.480.1264 > > cell: 250.920.8830 > > e-mail: [EMAIL PROTECTED] > > web: www.electricedgesystems.com > > > > Notice: > > This message, including any attachments, is confidential and may contain > > information that is privileged or exempt from disclosure. It is intended > > only for the person to whom it is addressed unless expressly authorized > > otherwise by the sender. If you are not an authorized recipient, please > > notify the sender immediately and permanently destroy all copies of this > > message and attachments. > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299306 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
