[mapserver-users] Getfeatureinfo and MSsql 2008 server

[Afroz K]

Dear Tamaz,
                I guess this cannot be done as I am not using QuerybyPoint.
I just use the GetfeatureInfo from my html page.

Thanks
Afroz

On Fri, Feb 26, 2010 at 2:06 AM, Tamas Szekeres <szekerest at gmail.com> wrote:

> Afroz,
>
> 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.
>
> Best regards,
>
> Tamas
>
>
>
> 2010/2/25 Afroz Kannancheri <afrozk at gmail.com>
>
>
>> Hi All,
>>
>> I have a layer drawn from the shape information stored in MSSQL 2008
>> server.
>> The layer has around 300 polygons which are drawn perfectly on a world
>> base
>> map.
>> When i try to get the details for each polygon using the Getfeatureinfo
>> during the click event, i get the following error from MSSQL 2008 server.
>>
>> msMSSQL2008LayerGetShape(): Query error. Error executing MSSQL2008 SQL
>> statement: SELECT convert(varchar(max), numb1),convert(varchar(max),
>> poprate),geom.STAsBinary(),convert(varchar(20), ID) from table1 WHERE
>> geom.STIntersects(Geometry::STGeomFromText('POLYGON((-16.4101563310658
>> 17.724609875,-16.4101563310658 17.724609875,-16.4101563310658
>> 17.724609875,-16.4101563310658 17.724609875,-16.4101563310658
>> 17.724609875))',0)) = 1 -[Microsoft][ODBC SQL Server Driver][SQL Server]A
>> .NET Framework error occurred during execution of user defined routine or
>> aggregate 'geometry': System.FormatException: 24118: The Polygon input is
>> not valid because the exterior ring does not have enough points. Each ring
>> of a polygon must contain at least three distinct points.
>> System.FormatException: at
>> Microsoft.SqlServer.Types.GeometryDataBuilder.EndFigure() at
>>
>> Microsoft.SqlServer.Types.OpenGisWktReader.ParseLineStringText(FigureAttributes
>> attributes) at
>> Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonText()
>> at Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonTaggedText() at
>> Microsoft.SqlServer.Types.OpenGisWktReader.ParseGeometryTaggedText() at
>> Microsoft.SqlServer.Types.OpenGisWktReader.ReadGeometry() at
>> Microsoft.SqlServer.Types.SqlGeometry.STGeomFromText(SqlChars
>> geometryTaggedText, Int32 srid)
>>
>>
>> Has anyone faced such an issue before.
>>
>>
>> Thanks and regards
>> AFroz Kannancheri
>> --
>> View this message in context:
>> http://n2.nabble.com/Getfeatureinfo-and-MSsql-2008-server-tp4631717p4631717.html
>> Sent from the Mapserver - User mailing list archive at Nabble.com.
>> _______________________________________________
>> 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/20100226/83c9534d/attachment.htm>