Paul, I don't see any compelling reason why these use cases wouldn't work. Could you provide a sample data/mapfile/example URL to reproduce this?
Best regards, Tamas 2010/2/25 Paul james <[email protected]> > The Mssql2008 driver is incomplete... > GetFeatureInfo, Nquery, Query doesnt work at all... > > http://trac.osgeo.org/mapserver/ticket/3058 > > Paul > > > On Thu, Feb 25, 2010 at 7:57 AM, Afroz Kannancheri <[email protected]>wrote: > >> >> 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-tp4631781p4631781.html >> Sent from the Mapserver - User mailing list archive at Nabble.com. >> _______________________________________________ >> mapserver-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> > > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
