Bug #61981 Spatial Function
Submitted: 26 Jul 2011 9:57 Modified: 26 Jul 2011 11:40
Reporter: Ahmad Abujoudeh Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: GIS Severity:S3 (Non-critical)
Version:5 OS:Any
Assigned to: CPU Architecture:Any
Tags: gis, spatial

[26 Jul 2011 9:57] Ahmad Abujoudeh
Description:
dear, i need to get distance between two point, so i use:
  ROUND(GLENGTH(LINESTRINGFROMWKB (LINESTRING(ASBINARY(l1.coord), ASBINARY(l2.coord))))) AS `distince`

but i get: FUNCTION LINESTRINGFROMWKB does not exist 

please help me

How to repeat:
aa
[26 Jul 2011 11:05] Valeriy Kravchuk
Try to remove extra space before (, like this:

ROUND(GLENGTH(LINESTRINGFROMWKB(LINESTRING(ASBINARY(l1.coord), ASBINARY(l2.coord))))) AS `distince`
[26 Jul 2011 11:35] Ahmad Abujoudeh
oh, thanks
[26 Jul 2011 11:39] Valeriy Kravchuk
I assume the problem is solved. Correct me if I am wrong.
[26 Jul 2011 11:41] Ahmad Abujoudeh
yes, l will closed it