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/
