[mapserver-users] Problem using getShape with MsSql2008 (Mapscript C#)

[Paul james]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090915/21e6d069/attachment.html