AnsweredAssumed Answered

Radius Search by Postal Code

Question asked by olivervollmer on Oct 1, 2018
Latest reply on Oct 2, 2018 by fmpdude

Hello,

I am looking for a way to find addresses in my db by entering a postal code and radius.

My tables:

- Contacts (postcode, city)

- Postal codes with geocodes (LAT/LON)

The both tables are related over the ZIP field.

 

I have created the CF GeoBoxBounds (https://www.briandunning.com/cf/1491) and it will calculate by entering a postal code and a radius. Now, I get in the calculation field 4 values:

 

 

Bildschirmfoto 2018-10-02 um 06.10.24.png

 

Now I would have to use a script over these values from the CF, in order to find the appropriate results.
But how should I build the search here?

 

I have attached an example so that my approach can be better understood.


Would be very grateful for help and support.

Attachments

Outcomes