[mapguide-users] MapGuide SQL2008 Provider: can't support geometry method?

[Carl]

I got it partially.

C:\Program Files\MapGuideOpenSource2.0\WebServerExtensions\Help\index.htm

I set the filter as:

Prj_Geometry INTERSECTS GEOMFROMTEXT ( 'POINT(1 1)' )

But sometimes the complicated spatial computation can only be done by the
datasource self. Maybe it is possible to add a bool tag to denote how to
parse the filter? by the provider or by MG OS Server?


Carl wrote:
> 
> I just had a post about SQL 2008 Provider and got many effective answers,
> and had my problem partially resolved.
> 
> Now I can add a layer referencing to a feature datasource of ms sql 2008. 
> 
> Further more, I need to give a filter to the layer to select part of
> features. if I give a common condition(i.e. the common boolean clause,
> such as " id='1' and name like '%_c' "), and the mapguide can give a
> correct response (i.e. the features on the map are just those selected).
> but if I give a spatial condition ( such as "Prj_Geometry.STIsClosed()=1
> "), Mapguide always return a map contains all features.
> 
> Is the boolean expression parsed by the datasource or by MapGuide Server
> itself? 
> 
> In my opinion, the filter string should be parsed and executed by the
> provider datasource, such as MS SQL server 2008.
> 
> could anybody help me?
> 

-- 
View this message in context: http://www.nabble.com/MapGuide-SQL2008-Provider%3A-can%27t-support-geometry-method--tp20056020p20056615.html
Sent from the MapGuide Users mailing list archive at Nabble.com.