FYI, it is SQL Server 2k5
.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -----Original Message----- From: Bobby Hartsfield [mailto:[email protected]] Sent: Tuesday, July 05, 2011 11:49 AM To: cf-talk Subject: RE: Postal radus searches Thanks Dominic. I'm not sure I follow your last comment though. Wouldn't that still require a maintained zipcode database with longs and lats? .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -----Original Message----- From: Dominic Watson [mailto:[email protected]] Sent: Tuesday, July 05, 2011 11:07 AM To: cf-talk Subject: Re: Postal radus searches I know that Solr was working on this for its next release (I was looking over 6 months ago). This would allow free text geographical searching which may be overkill for what you need but may be able to just do what you're looking for too. It may also be worth looking at your db engine, some have spatial data types that support distance calculations and such. HTH Dominic On 5 July 2011 14:38, Bobby Hartsfield <[email protected]> wrote: > > Hey All, > > It has been a long time since I did a postal code readius search. All of the > ones I did in the past involved purchasing and maintaining a postal code > database and I was hoping there were some pretty solid services out there > for it by now so I didn't have to do that anymore. > > Do any of you know of any services out there that you would qualify as > "solid" that you can just pass a zip and a distance to and have it send back > the zips that it finds in the radius? > > I've heard that Google has one and wondered if anyone uses that one in a > live app as well. > > Thanks. > > > .:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > http://cf4em.com > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346074 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
