Re: [DFW CFUG] Zip code proximity

Wed, 21 Mar 2007 15:04:29 -0800 

Thanks Derek, that'd be awesome! :o)

I'm really looking forward to seeing your cfc.

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 via email to