Member
> ---
>
>
> > From: Hank <[EMAIL PROTECTED]>
> > Reply-To: Hank <[EMAIL PROTECTED]>
> > Date: Sun, 9 Oct 2005 11:12:10 -0400
> > To: "Steffan A. Cline" <[EMAIL PROTECTED]>
lications
Lasso Partner Alliance Member
---
> From: Hank <[EMAIL PROTECTED]>
> Reply-To: Hank <[EMAIL PROTECTED]>
> Date: Sun, 9 Oct 2005 11:12:10 -0400
> To: "Steffan A. Cline" <[EMAIL PROTECTED]>
>
Don't forget that you're not caclucating "driving distance", but
"great circle" distance, which is roughly a straight line over short
distances. If you radius is great than, say 50 miles, people might
complain that the actual driving distance is much greater than the
straight line distance you pro
Ok. I think I have what I need... Almost. Here is the query I settled on:
SELECT b.zip, b.state,b.storename,
(3956 * (2 * ASIN(SQRT(
POWER(SIN(((a.lat-b.lat)*0.017453293)/2),2) +
COS(a.lat*0.017453293) *
COS(b.lat*0.017453293) *
I saw those and several on finding matches and are close but the problem I
ran into is that yeah.. they find all of the zips within the specified
radius but I need to the matches that came from another table.
Thanks
Steffan
---
T E L
At 05:59 PM 10/8/2005, you wrote:
I was wondering if anyone might have a canned query I could use for the
following scenario.
I need to search for a list of locations within a certain distance of a user
given zip code and order them by driving distance calculated from a table of
zip codes contai
