<div dir="ltr"><div>Dear Tamaz,</div>
<div> I guess this cannot be done as I am not using QuerybyPoint. I just use the GetfeatureInfo from my html page.<br><br>Thanks </div>
<div>Afroz</div>
<div> </div>
<div class="gmail_quote">On Fri, Feb 26, 2010 at 2:06 AM, Tamas Szekeres <span dir="ltr"><<a href="mailto:szekerest@gmail.com">szekerest@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Afroz,<br><br>This error message says you must specify a search shape with area > 0 during the query. Assuming you use a queryByPoint operation, either the buffer parameter of the tolerance of the layer should be specified as a positive number.<br>
<br>Best regards,<br><br>Tamas<br> <br><br><br>
<div class="gmail_quote">2010/2/25 Afroz Kannancheri <span dir="ltr"><<a href="mailto:afrozk@gmail.com" target="_blank">afrozk@gmail.com</a>></span>
<div>
<div></div>
<div class="h5"><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid"><br>Hi All,<br><br>I have a layer drawn from the shape information stored in MSSQL 2008 server.<br>
The layer has around 300 polygons which are drawn perfectly on a world base<br>map.<br>When i try to get the details for each polygon using the Getfeatureinfo<br>during the click event, i get the following error from MSSQL 2008 server.<br>
<br>msMSSQL2008LayerGetShape(): Query error. Error executing MSSQL2008 SQL<br>statement: SELECT convert(varchar(max), numb1),convert(varchar(max),<br>poprate),geom.STAsBinary(),convert(varchar(20), ID) from table1 WHERE<br>
geom.STIntersects(Geometry::STGeomFromText('POLYGON((-16.4101563310658<br>17.724609875,-16.4101563310658 17.724609875,-16.4101563310658<br>17.724609875,-16.4101563310658 17.724609875,-16.4101563310658<br>17.724609875))',0)) = 1 -[Microsoft][ODBC SQL Server Driver][SQL Server]A<br>
.NET Framework error occurred during execution of user defined routine or<br>aggregate 'geometry': System.FormatException: 24118: The Polygon input is<br>not valid because the exterior ring does not have enough points. Each ring<br>
of a polygon must contain at least three distinct points.<br>System.FormatException: at<br>Microsoft.SqlServer.Types.GeometryDataBuilder.EndFigure() at<br>Microsoft.SqlServer.Types.OpenGisWktReader.ParseLineStringText(FigureAttributes<br>
attributes) at Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonText()<br>at Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonTaggedText() at<br>Microsoft.SqlServer.Types.OpenGisWktReader.ParseGeometryTaggedText() at<br>
Microsoft.SqlServer.Types.OpenGisWktReader.ReadGeometry() at<br>Microsoft.SqlServer.Types.SqlGeometry.STGeomFromText(SqlChars<br>geometryTaggedText, Int32 srid)<br><br><br>Has anyone faced such an issue before.<br><br><br>
Thanks and regards<br>AFroz Kannancheri<br><font color="#888888">--<br>View this message in context: <a href="http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631717p4631717.html" target="_blank">http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631717p4631717.html</a><br>
Sent from the Mapserver - User mailing list archive at Nabble.com.<br>_______________________________________________<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></font></blockquote></div></div></div><br></blockquote></div><br></div>