Proximity search by zip code?

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Proximity search by zip code?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Proximity search by zip code?

Page: [1]


travismp Posts: 215 Joined: 2/1/2002 From: hutchinson ks USA Status: offline	Proximity search by zip code? - 5/5/2008 9:31:14 I have a current ASP page where a user can search by city, st, or zip code and it will show results based on the search criteria. If my user types a zip code that is not in our DB then it says "no results found" How do I set up a search by proximity field? Thank you.


travismp Posts: 215 Joined: 2/1/2002 From: hutchinson ks USA Status: offline	RE: Proximity search by zip code? - 5/5/2008 9:50:21 Also I am willing to buy software if needed to make it work easier. Thanks. (in reply to travismp)


rdouglass Posts: 9137 From: Biddeford, ME USA Status: offline	RE: Proximity search by zip code? - 5/5/2008 10:26:55 I built one using a Public Domain ZIP code DB that lists the longitude and lattitude of the ZIP code. Then I use a stored procedure that uses the Pythagorean theorem to find the closest ZIPs. I would not recommend this with an Access DB at all but rather SQL Server. (Well this stored procedure is for MS SQL so I guess that's what I recommend. ) How comfortable are you with SQL Stored Procedures? _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to travismp)


travismp Posts: 215 Joined: 2/1/2002 From: hutchinson ks USA Status: offline	RE: Proximity search by zip code? - 5/5/2008 10:31:05 I have no working knowledge of SQL at all. Also there is not a SQL application loaded on the web server. (in reply to rdouglass)


rdouglass Posts: 9137 From: Biddeford, ME USA Status: offline	RE: Proximity search by zip code? - 5/5/2008 10:46:18 My solution won't help then - it does require SQL Server. Sorry. What databse engines are available to you? mySQL? I wouldn't know personally but I bet you could do the same with mySQL and stored procedures. I'm not familiar with one but I'm pretty confident they're out there somewhere. And the procedure is not anything MS SQL specific that I can see. I wouldn't touch this with Access. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to travismp)


travismp Posts: 215 Joined: 2/1/2002 From: hutchinson ks USA Status: offline	RE: Proximity search by zip code? - 5/5/2008 11:01:01 That is OK, thank you for the consideration. Eventually I will have SQL available, but right now it is not an option. I may just put the project off until then. Thank you rdouglass. (in reply to rdouglass)

Page: [1]

All Forums >> Web Development >> ASP and Database >> Proximity search by zip code?

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts