RE: [mapguide-users] MySQL Spatial Queries with FDO

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

RE: [mapguide-users] MySQL Spatial Queries with FDO

Greg Boone
Please post FDO specific question to the FDO Users Mail List:

[hidden email]

Greg

-----Original Message-----
From: [hidden email]
[mailto:[hidden email]] On Behalf Of George
McLean
Sent: Thursday, February 15, 2007 5:40 PM
To: MapGuide Users Mail List
Subject: [mapguide-users] MySQL Spatial Queries with FDO

I am having trouble writing spatial queries against MySQL 5.0.18 using
the OSGeo.MySQL.3.2 provider

I pass the string 'geometry INTERSECTS GEOMFROMTEXT ('POINT XY (2536400
481800)')' to the SetFilter method of an MgFeatureQueryOptions object.
When I call selectFeatures from a feature service object, I get no
errors.

When I use the filter string 'geometry INTERSECTS GEOMFROMTEXT
('LINESTRING XY (2536400 481800, 2536500 481900)')' I get the following
error on selection:

An exception occurred in FDO component. String does not represent a
valid filter.

As far as I can tell the query string is OK. I have the same problem
with using POLYGON as the geometry as well. Only POINT seems to work.
When I query the capabilities of the MySQL provider it appears to me
that LINESTRING and POLYGON are supported.

Any suggestions?

Thanks

George McLean



_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users