Building a Search By Distance Form

[kammsba]

I'd like to build a search form which allows members to get results of school districts within so many miles of their own district. Is this possible? How do I start? Thanks!

 

[GUJUm0deL]

kammsba, what kind of dB will you be using?

The easiest way would be asking the users for their zipcode and then create a query that will only return results of school districts that are within a certain range (in terms of miles) from the users zipcode.

And to avoid asking for the users zipcode over and over again, use CFCOOKIES or something that "remembers" the users zip.

Hope this helps you.

[sub]
____________________________________
Just Imagine.

http://www.imajinarts.com

[sub]

 

[ecobb]

Just out of curiosity, how would you go about determining the mileage between each zip code? I've often wondered how this was done.



Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

 

[bhightower]

you might try searching by zip codes...
here is some info on how to do this.....

http://tutorial153.easycfm.com/

------------------------------------------------------------------------------
brannonH
if( !succeed ) try( );

 

[philhege]

The first thing you need is a database that geocodes ZIP codes, that is, assigns some version of an X and Y coordinate to the ZIP code record. This is the "ballpark" method; ZIP areas vary in size. You can use the simple right triangle distance formula, or introduce the fudge factors for latitude and longitude if you want get fancy.

You'll still have to disclaim your tool with "as the crow flies", because you're not presenting a true point-to-point.

HTH,

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....