Thanks Chris...I'll take a peek ;-) 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. On Mon, 2008-02-18 at 17:02 -0600, Chris Jordan wrote: > 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:299311 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
