Another issue coul be that the layer type is not compatible with the geometry type, like the following combinations are invalid with this driver:<br><br>Layer type shape geom type<br><br>line point<br>
polygon point<br>polygon line<br><br><br>I'd also be curious about the wkb of your geometry<br><br>Could you dump your related feature table in the SQL management studio query analyzer?<br>
<br>select * from [table] where [id]=10<br><br>or something like this...<br><br>Best regards,<br><br>Tamas<br><br><br><div class="gmail_quote">2009/8/7 Paul james <span dir="ltr"><<a href="mailto:pauljame@gmail.com">pauljame@gmail.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;">Yes.... But the same code with a Postgis db is ok...<br>Image attached<br><font color="#888888"><br>
Paul</font><div><div></div><div class="h5"><br><br><div class="gmail_quote">On Fri, Aug 7, 2009 at 11:21 AM, Tamas Szekeres <span dir="ltr"><<a href="mailto:szekerest@gmail.com" target="_blank">szekerest@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">This appears to be a null shape with no valid geometry. (type=3, numlines = 0)<br><br>Best regards,<br>
<br>Tamas<br><br><br><br><div class="gmail_quote">2009/8/7 Paul james <span dir="ltr"><<a href="mailto:pauljame@gmail.com" target="_blank">pauljame@gmail.com</a>></span><div><div></div><div><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">The layer geometry is fine...<br>I“m sending a shape property screenshot...<br><font color="#888888"><br>
Paul</font><div><div></div><div><br><br><div class="gmail_quote">On Fri, Aug 7, 2009 at 5:25 AM, Tamas Szekeres <span dir="ltr"><<a href="mailto:szekerest@gmail.com" target="_blank">szekerest@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Paul,<br><br>There is a function (find_bounds) calculating the bounds in mapmssql2008.c which should provide correct results.<br>
Could you check whether the returned geometry is correct by dumping the point coordinates of each lines in mapscript?<br>
<br>Best regards,<br><br>Tamas<br><br><br><div class="gmail_quote">2009/8/6 Paul james <span dir="ltr"><<a href="mailto:pauljame@gmail.com" target="_blank">pauljame@gmail.com</a>></span><div><div></div><div>
<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Just an update...<br>The shape values are all there... The only thing is wrong is the bounds (-1) ...<div><div></div><div><br><br><div class="gmail_quote">On Wed, Aug 5, 2009 at 5:44 PM, Paul james <span dir="ltr"><<a href="mailto:pauljame@gmail.com" target="_blank">pauljame@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I“ll check...<br>But the same layer/id worked fine using Postgis... So I should be a bug...<br>
<font color="#888888"><br>Paul</font><div><div></div><div><br><br><div class="gmail_quote">On Wed, Aug 5, 2009 at 5:38 PM, Tamas Szekeres <span dir="ltr"><<a href="mailto:szekerest@gmail.com" target="_blank">szekerest@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,<br><br>I think you should check the sql statement submitted by the driver by using the SQL Profiler. I suspect no records have been retrieved during the fetch.<br>
<br>Best regards,<br><br>Tamas<br><br><br><div class="gmail_quote">
2009/8/5 Paul james <span dir="ltr"><<a href="mailto:pauljame@gmail.com" target="_blank">pauljame@gmail.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;">
<div><div></div><div>
Hello guys...<br>That code is working fine with Postgis:<br><br>_layer.open();<br>var _shape = new shapeObj((int)_layer.type);<br>_layer.getShape(_shape, 0, __id.ToInt32());<br><br>The _shape.bounds are all -1 using MsSql2008 ... <br>
<br>Any idea?<br>
<br></div></div>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">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>
<br></blockquote></div><br>
</blockquote></div><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div></div></div><br>
</blockquote></div><br>
</div></div></blockquote></div></div></div><br>
</blockquote></div><br>
</div></div></blockquote></div><br>