Store Locator

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
See the link I posted.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
I told him that way at the beginning.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
 
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.
 
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.
 
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) :-)
 
Of course, then there is the potential problem when you have zips in NJ -
09513, for example. Numeric fields drop that leading zero.
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Print Files from Query Results 0
Assume I create a class Customer is it advice to have a separate class to store addresses 6
Dropdown choices populated by a sharepoint 2003 list 1
Zip Code Search Advice 3
storing feedback 3
Not sure what I need... 2
Vodafone - the worst customer service I've ever had 8
vlookup returns last value in array 3

Back
Top