September 27, 2007 at 2:30 pm
Comments posted to this topic are about the item Determine Distance Between Any Two Locations
Karen Gayda
MCP, MCSD, MCDBA
gaydaware.com
June 9, 2008 at 1:50 pm
Thanks alot for the clean and good function!!
Kind regards,
Wim
July 17, 2008 at 9:28 am
There is one issue in the CalcDistanceBetweenGeoLocations function. Sometime you will get an error, "A domain error occurred.", by passing in some specific parameters.
So I added the following Code:
--reset @Distance if it is out of the range of (-1,1)
If @Distance>1
set @Distance=1
If @Distance<-1
set @Distance=-1
before
--Get distance in miles
SET @Distance = (DEGREES(ACOS(@Distance))) * 69.09
Because ACOS can be only with a value from -1 through 1.
October 13, 2008 at 5:58 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply