I've created a page using the ASP.VBScript server model and have two databases - a 2004 US zip code db w/logitude and latitude stats, and a database of stores with their locations including zip. Does anyone know how to create a store locator using Dreamweaver and these two Access databases?
Thanks for any help you can provide.
Margot
margot 0 Newbie Poster
Lafinboy 4 Junior Poster
You can find a good example and working code (perl) at which will give a distance between two long/lat values in a number of units (km, miles, nautical miles). You will need to modify the code/implement the maths into your asp code and sql selection data from the database to determine distances between zips.
It's a real headspin to get your head around the maths, but well worth it to understand what is happening.
If you need help give me a shout.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.