[mapserver-users] msplugin_mssql2008 and getFeature()

[Tamas Szekeres]

Gabe,

I suspect your issue may be related to some parsing problem with the DATA
section. I think you might want to try defining a single view for your data
and then use this view to define the DATA section like:

gExtent from MyView using unique [iId] using SRID=4326


Best regards,

Tamas



2010/2/3 Gabe Codina <Gabe at agtrix.com>

> Hi All
>
> I have a web mapping app based on ms 5.2.1 and php mapScript.  Our business
> layers are stored in MSSQL2008 and were transferred from postgis some time
> ago.
>
> I have a requirement to highlight selected features on the map - the way
> this used to work was I would add a highlight layer to the map and  addthe
> selected features to it by using getShape and addFeature.
>
> Using the mssql plugin my calls to getShape (and getFeature) always return
> FALSE.  I know the features are there but they cannot be retrieved.
>
> Info:
>
> Sample data statement
>
>    DATA "gExtent FROM (SELECT [iId],geometry::STGeomFromWKB([binExtentWKB],
> 4326) AS gExtent
>      ,[cIdentifiers],[cLabel],[iSessionId] FROM
> [Scratch].[tManagementUnitsGeometry] WHERE [iSessionId] = 310) AS FOO USING
> UNIQUE [iId] USING SRID=4326"
>
> Some Mapscript
>
>               if ($resTileShpIdx){
>                    $resShape = $qLayer->getShape($resTileShpIdx,
> $resShpIdx);
>                } else {
>                    $resShape = $qLayer->getFeature($resShpIdx);
>                }
>
> ...
>
>
>                $newResLayer->addFeature($resShape);
>
>
> Any help will be greatly appreciated.
>
> Gabe Codina
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100203/7f7d2b6c/attachment.html