Help with Lat long
Posted: Tue Apr 06, 2010 1:03 pm
Hi, i have a database that has a lat long for each entry .
I have a query that supplies the lat longs of all entires within a lat long window what i want to do is calculate the distance between each set of lat longs and a base lat long ( i can do the calculation fine) i need to then sort all my entries based on this calculated distance how would i go about this?
I have a query that supplies the lat longs of all entires within a lat long window what i want to do is calculate the distance between each set of lat longs and a base lat long ( i can do the calculation fine) i need to then sort all my entries based on this calculated distance how would i go about this?