Hi Christopher, Sorry for the delay. I was mistaken, the core 'calculations' were not in a CFC but a custom tag. I emailed the files directly to you ( don't know if you can do files on the list ).
Hopefully you can use some of the code to achieve what you are trying to do. Derek On 3/22/07, Christopher Jordan <[EMAIL PROTECTED]> wrote:
Hi Derek. Any chance of getting that CFC? I'm still interested in looking at it. Thanks, Chris derek bumpas wrote: > Sorry..I mis-read your post. > > I'll post the CFC I use this evening when I get home. > > Derek > > > On 3/20/07, *derek bumpas* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> > wrote: > > I'm pretty sure all of the local (not webservice solutions) will use > Long/Lat to determine distance. > > I have experience building proximity search apps and can assist if > needed. > > Derek > > > > On 3/20/07, *Christopher Jordan* <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> 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] <mailto:[email protected]> > Subscribe/Unsubscribe: > http://lists1.safesecureweb.com/mailman/listinfo/list > <http://lists1.safesecureweb.com/mailman/listinfo/list> > List Archives: > http://www.mail-archive.com/list%40list.dfwcfug.org/ > <http://www.mail-archive.com/list%40list.dfwcfug.org/> > http://www.mail-archive.com/list%40dfwcfug.org/ > <http://www.mail-archive.com/list%40dfwcfug.org/> > DFWCFUG Sponsors: > www.instantspot.com/ <http://www.instantspot.com/> > www.teksystems.com/ <http://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/
_______________________________________________ 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/
