MySQL Forums
Forum List  »  GIS

distance between two points
Posted by: Lukasz Nowak
Date: April 10, 2010 03:58PM

Hi, I have some problems with detecting distance by lenght of LineString

AsBinary() is working well but when I want to create LineStringFromWKB I recieve only NULL

it is my sql:

SELECT ROUND( GLength( LineStringFromWKB( LineString( AsBinary( a.g ) , AsBinary( b.g ) ) ) ) ) AS dis
FROM cities a, cities b
WHERE a.name = 'Zakopane'
AND b.name = 'Warszawa'

-------
dis
NULL


PLEASE HELP

Options: ReplyQuote


Subject
Views
Written By
Posted
distance between two points
4615
April 10, 2010 03:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.