<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html><head> <meta content="text/html; charset=utf-8" http-equiv="Content-Type"> </head>Dear tamas, <br/>I'll try the buffer parameter that u have mentioned once I m back in office on sunday and update u guys about the output.<br/><br/>Thanks a lot guys..<p>Sent from my BlackBerry® smartphone from du</p><hr/><div><b>From: </b> Tamas Szekeres <szekerest@gmail.com>
</div><div><b>Date: </b>Thu, 25 Feb 2010 23:06:47 +0100</div><div><b>To: </b>Afroz Kannancheri<afrozk@gmail.com></div><div><b>Cc: </b><mapserver-users@lists.osgeo.org></div><div><b>Subject: </b>Re: [mapserver-users] Getfeatureinfo and MSsql 2008 server</div><div><br/></div> 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">afrozk@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;">
<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">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><br>
</html>