Tamas, The last problem with getShape is solved and working fine.... But now I got other possible bug using MsSql2008/C# ...
Code : MapObj.queryByPoint(_oGeo, mapscript.MS_MULTIPLE, -1) Thas is working fine with Postgis... But wth MsSql2008, got the following error : (using queryByRect all works fine) msMSSQL2008LayerGetShape(): Query error. Error executing MSSQL2008 SQL statement: SELECT convert(varchar(max), oid),convert(varchar(max), anoreferencia),convert(varchar(max), uf),convert(varchar(max), rodovia),convert(varchar(max), codigopnv),convert(varchar(max), localiniciofim),convert(varchar(max), inicio),convert(varchar(max), fim),convert(varchar(max), extensao),convert(varchar(max), superficie),convert(varchar(max), listacoincidente),convert(varchar(max), estadualcoincidente),convert(varchar(max), superficieestadualcoincidente),convert(varchar(max), mp_082),convert(varchar(max), concessaoconvenio),the_geom.STAsBinary(),convert(varchar(20), oid) from viwgeo_test WHERE the_geom.STIntersects(Geometry::STGeomFromText('POLYGON((-74.6741893243784 2.46256865079364,-74.6741893243784 2.46256865079364,-74.6741893243784 2.46256865079364,-74.6741893243784 2.46256865079364,-74.6741893243784 2.46256865079364))',0)) = 1 -[Microsoft][ODBC SQL Server Driver][SQL Server]: System.FormatException: 24305: The Polygon input is not valid because the ring does not have enough distinct points. Each ring of a polygon must contain at least three distinct points. System.FormatException: at Microsoft.SqlServer.Types.Validator.Execute(Transition transition) at Microsoft.SqlServer.Types.Validator.EndFigure() at Microsoft.SqlServer.Types.ForwardingGeoDataSink.EndFigure() at Microsoft.SqlServer.Types.OpenGisWktReader.ParseLineStringText() at Microsoft.SqlServer.Types.OpenGisWktReader.ParsePolygonText() at Microsoft.SqlServer.Types.OpenGisWktReader.ParseTaggedText(OpenGisType type) at Microsoft.SqlServer.Types.OpenGisWktReader.Read(OpenGisType type, Int32 srid) at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid) at Microsoft.SqlServer.Types.SqlGeometry.STGeom
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users