Store Locator

[=?Windows-1252?Q?Rob_Giordano_\=28Crash_Gordon=AE\]

yes, that's what i mean - i think your lat/long is the only accurate way to do this - i was trying to point that out, and confirm my conjecture.

 

[Thomas A. Rowe]

See the link I posted.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Kevin Spencer]

I told him that way at the beginning.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

 

[Kevin Spencer]

Read the whole thread. I explained the correct way to him at first. He
didn't want to go with it.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

in message what i mean is that 85260 is not necessarily physically located near 85261
(mileage-wise) so while they are numerically bracketted they might not be
close to the user...so the only way it would be accurate is using map
coordinates as you mentioned earlier.

 

[Kevin Spencer]

Yes, since the numbers are aphabetically in the same order as numerically.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

 

[Kevin Spencer]

Yes, "simple" is one of the words I use to identify the level of the
developer. Pros generally avoid using the word, as they know better! ;-)

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

in message i think the only accurate way to do it would be with coordinates, as kevin
mentioned earlier.

funny how simple things aren't.

i'd run into this trying to coordinate an online car pool feature for my
son's high school...proved to be too daunting for the amount they were
paying (zippo)

 

[Murray]

Of course, then there is the potential problem when you have zips in NJ -
09513, for example. Numeric fields drop that leading zero.

 

[Kevin Spencer]

True. ZipCodes are stored as strings everywhere I've seen. You could still
use BETWEEN in the query though.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

 

[Murray]

Hmm - the between works on the ASCII value?

 

[Kevin Spencer]

It works on strings. At least in some databases (e.g.SQL Server).

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

 

[Windsun]

There is nothing simple about what you are describing. For an example go to
Google maps

http://maps.google.com/