Thanks Rick, I'll have a look....guess sometimes the best way is still the old way eh ;-)
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 Tue, 2008-02-19 at 07:55 -0500, Rick Root wrote: > On 2/18/08, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > > > 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? > > postal code data. The fastest and most reliable way to do it. You > can integrate it into your queries. Can't do that with a web > service/API call. > > We're basically using a variation of this code in our application here at > Duke: > > http://www.opensourcecf.com/1/2007/02/Determining-Zip-Code-Proximity.cfm > > There's also a link on that page to a $5 zip code lat/long database that we > use. > > Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:299331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
