Gabe,<br><br>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:<br>
<br>gExtent from MyView using unique [iId] using SRID=4326<br><br><br>Best regards,<br><br>Tamas<br><br><br><br><div class="gmail_quote">2010/2/3 Gabe Codina <span dir="ltr"><<a href="mailto:Gabe@agtrix.com">Gabe@agtrix.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi All<br>
<br>
I have a web mapping app based on ms 5.2.1 and php mapScript. Our business<br>
layers are stored in MSSQL2008 and were transferred from postgis some time<br>
ago.<br>
<br>
I have a requirement to highlight selected features on the map - the way<br>
this used to work was I would add a highlight layer to the map and addthe<br>
selected features to it by using getShape and addFeature.<br>
<br>
Using the mssql plugin my calls to getShape (and getFeature) always return<br>
FALSE. I know the features are there but they cannot be retrieved.<br>
<br>
Info:<br>
<br>
Sample data statement<br>
<br>
DATA "gExtent FROM (SELECT [iId],geometry::STGeomFromWKB([binExtentWKB],<br>
4326) AS gExtent<br>
,[cIdentifiers],[cLabel],[iSessionId] FROM<br>
[Scratch].[tManagementUnitsGeometry] WHERE [iSessionId] = 310) AS FOO USING<br>
UNIQUE [iId] USING SRID=4326"<br>
<br>
Some Mapscript<br>
<br>
if ($resTileShpIdx){<br>
$resShape = $qLayer->getShape($resTileShpIdx,<br>
$resShpIdx);<br>
} else {<br>
$resShape = $qLayer->getFeature($resShpIdx);<br>
}<br>
<br>
...<br>
<br>
<br>
$newResLayer->addFeature($resShape);<br>
<br>
<br>
Any help will be greatly appreciated.<br>
<br>
Gabe Codina<br>
<br>
<br>
_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</blockquote></div><br>