[mapguide-users] MapGuide SQL2008 Provider: can't support geometry
Kenneth Skovhede, GEOGRAF A/S
ks at geograf.dk
Mon Oct 20 04:07:18 EDT 2008
There exists an FDO command that allows you you to pass the query
directly to the datasource.
AFAIK, that is not possible to do with a layer filter.
Instead, you can create a view in the database with the appropriate
filter, and then use that view as your datasource.
Regards, Kenneth Skovhede, GEOGRAF A/S
> 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
>> 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?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mapguide-users