As I recall, this article tells you where to get the zip code
database. My suggestion is to update yours with the new info
containing the longitude and latitude. That would be the easiest.
Otherwise you have to fix it the exisitng cfc! I don't know how else
you would do it unless your existing db contains some relationship
table with zipcodes that are actually proximal (right next to each
other). I'd like to see the query for finding a radius of 3 zipcodes
out!
Sounds like a new CFUG brainteaser!
Thanks,
Joe Kelly
On 3/20/07, Adrian J. Moreno <[EMAIL PROTECTED]> wrote:
Found an article at CFDJ (beware auto-playing video ads)
Building a Zip Code Proximity Search with ColdFusion
http://coldfusion.sys-con.com/read/154258.htm
HTH,
Adrian
Christopher Jordan wrote:
> Hi folks,
>
> I've inherited a piece of code that does a zip code proximity search,
> and as it turns out: it's busted.
>
> I've been searching the web (in general) and RIAForge and CF-Talk (where
> there have been a couple discussions on this). Unfortunately, I've not
> found a solution I like. I did find something called zipfinder.cfc
> (which is the sort of solution I'm looking for) that was written by
> Robert Capili, but he includes a zip database that has a couple of
> fields that my existing zip database does not contain - namely the
> rlatitude and the rlongitude - and these are in addition to the normal
> latitude and longitude fields. Without these two special fields his cfc
> doesn't work. :o( I've emailed him to see if the component could be
> modified to work without these fields, but I've not heard from him yet.
>
> So I'm wonderin'... what does everyone here (whose had a need to do so)
> use to do proximity searches?
>
> I'm hoping for a CFC or something rather than a bunch of sql statements.
> I suppose that if I have to I can take some of the SQL examples that
> I've seen and put them into a component myself, but I'd rather not
> reinvent the wheel if I don't have to.
>
> What are everybody's thoughts on this subject?
>
> Cheers,
> Chris
>
> _______________________________________________
> Reply to DFWCFUG: [email protected]
> Subscribe/Unsubscribe:
> http://lists1.safesecureweb.com/mailman/listinfo/list
> List Archives:
> http://www.mail-archive.com/list%40list.dfwcfug.org/
> http://www.mail-archive.com/list%40dfwcfug.org/
> DFWCFUG Sponsors: www.instantspot.com/
> www.teksystems.com/
>
>
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.instantspot.com/
www.teksystems.com/
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.instantspot.com/
www.teksystems.com/
