<div>Thanks Steve...</div>
<div>Trying execute a query point like that:</div>
<div><a href="http://localhost/cgi-bin-last/mapserv.exe?map=C:/map.map&mode=query&LAYERS=UF&mapext=-56.798017578125+-14.26017890625+-56.578291015625+-14.04045234375&imgext=-56.798017578125+-14.26017890625+-56.578291015625+-14.04045234375&map_size=1217+680&imgxy=1217+680&img.x=608.5&img.y=340">http://localhost/cgi-bin-last/mapserv.exe?map=C:/map.map&mode=query&LAYERS=UF&mapext=-56.798017578125+-14.26017890625+-56.578291015625+-14.04045234375&imgext=-56.798017578125+-14.26017890625+-56.578291015625+-14.04045234375&map_size=1217+680&imgxy=1217+680&img.x=608.5&img.y=340</a></div>
<div> </div>
<div> generated that error :</div>
<div> </div>
<div>msMSSQL2008LayerGetShape(): Query error. Error executing MSSQL2008 SQL statement: SELECT convert(varchar(max), oid),convert(varchar(max), codigouf),convert(varchar(max), codigoregiao),convert(varchar(max), nomeuf),convert(varchar(max), siglauf),the_geom.STAsBinary(),convert(varchar(20), oid) from viwgeo_uf WHERE the_geom.STIntersects(Geometry::STGeomFromText('POLYGON((-56.6879924952826 -14.1504774265924,-56.6879924952826 -14.1504774265924,-56.6879924952826 -14.1504774265924,-56.6879924952826 -14.1504774265924,-56.6879924952826 -14.1504774265924))',0)) = 1 </div>
<div> </div>
<div>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 </div>
<div> </div>
<div> </div>
<div>Paul<br><br> </div>
<div class="gmail_quote">On Fri, Oct 30, 2009 at 2:48 PM, Steve Lime <span dir="ltr"><<a href="mailto:Steve.Lime@dnr.state.mn.us">Steve.Lime@dnr.state.mn.us</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Probably. Does a point query work? I reassigned the ticket to the keeper<br>of the SQLServer<br>driver in hopes that it gets attention.<br>
<br>Curiously, have you tried 5.6 at all with SQLServer?<br><br>Steve<br><br>>>> On 10/30/2009 at 12:22 PM, in message<br><<a href="mailto:33fad6880910301022s40c76f88ha011362964e21808@mail.gmail.com">33fad6880910301022s40c76f88ha011362964e21808@mail.gmail.com</a>>, Paul<br>
<div>
<div></div>
<div class="h5">james<br><<a href="mailto:pauljame@gmail.com">pauljame@gmail.com</a>> wrote:<br>> I think so...<br>> Is it related with that ticket?<br>> <a href="http://trac.osgeo.org/mapserver/ticket/3058" target="_blank">http://trac.osgeo.org/mapserver/ticket/3058</a><br>
><br>> Paul<br>><br>> On Fri, Oct 30, 2009 at 1:53 PM, Steve Lime<br><<a href="mailto:Steve.Lime@dnr.state.mn.us">Steve.Lime@dnr.state.mn.us</a>>wrote:<br>><br>>> Odd. Unfortunately I can't debug anything related to MSSQL2008,<br>
perhaps<br>>> the driver isn't<br>>> supporting functions necessary to complete a query?<br>>><br>>> Steve<br>>><br>>> >>> On 10/30/2009 at 6:33 AM, in message<br>>> <<a href="mailto:33fad6880910300433i342c619am99935a607896643f@mail.gmail.com">33fad6880910300433i342c619am99935a607896643f@mail.gmail.com</a>>, Paul<br>
>> james<br>>> <<a href="mailto:pauljame@gmail.com">pauljame@gmail.com</a>> wrote:<br>>> > Hey Steve...<br>>> ><br>>> > Yes I had...<br>>> > QUERYMAP<br>>> > COLOR 255 0 0<br>
>> > SIZE -1 -1<br>>> > STATUS ON<br>>> > STYLE hilite<br>>> > END<br>>> ><br>>> > With Status OFF I got that :<br>>> > Content-type: text/html<br>>> ><br>
>> > Using MSSQL2008<br>>> ><br>>> > Paul<br>>> ><br>>> ><br>>> > On Thu, Oct 29, 2009 at 6:13 PM, Steve Lime<br>>> <<a href="mailto:Steve.Lime@dnr.state.mn.us">Steve.Lime@dnr.state.mn.us</a>>wrote:<br>
>> ><br>>> >> Do you have a querymap object configured with status on? I would<br>>> guess<br>>> >> so in order to see that<br>>> >> error. What happens if you set STATUS OFF in the querymap?<br>
>> >><br>>> >> >>> On 10/29/2009 at 7:57 AM, in message<br>>> >> <<a href="mailto:33fad6880910290557m71ee3fdatd470590e3256f175@mail.gmail.com">33fad6880910290557m71ee3fdatd470590e3256f175@mail.gmail.com</a>>,<br>
Paul<br>>> >> james<br>>> >> <<a href="mailto:pauljame@gmail.com">pauljame@gmail.com</a>> wrote:<br>>> >> > Hello guys...<br>>> >> > Ím got this error when trying to execute a Nquery :<br>
>> >> ><br>>> >><br>>> >><br>>> ><br>>><br>>><br>><br><a href="http://localhost/cgi-bin-54/mapserv.exe?map=Map.map&mode=nquery&LAYERS=TEST&mape" target="_blank">http://localhost/cgi-bin-54/mapserv.exe?map=Map.map&mode=nquery&LAYERS=TEST&mape</a><br>
<br>><br>>><br>>> > x<br>>> >><br>>> >> ><br>>> >><br>>> >><br>>> ><br>>><br>>><br>><br>t=-58.358076171875+-11.42570625+-57.193525390625+-10.37101875&imgext=-58.35807<br>
><br>>> > 61718<br>>> >> ><br>>> >><br>>> >><br>>> ><br>>><br>>><br>><br>75+-11.42570625+-57.193525390625+-10.37101875&map_size=1221+762&imgxy=1221+762&i<br>
><br>>> > mgb<br>>> >> > ox=0+0+1221+762<br>>> >> ><br>>> >> > msDrawMap(): Image handling error. Failed to draw layer named<br>>> >> 'TEST'.<br>
>> >> ><br>>> >> > But, If I execute the same url with "mode=map", the image is<br>>> >> generated<br>>> >> > fine... What this error means?<br>>> >> ><br>
>> >> ><br>>> >> > TEST Layer<br>>> >> ><br>>> >> > LAYER<br>>> >> > NAME TEST<br>>> >> > GROUP "TE"<br>>> >> > TYPE polygon<br>
>> >> > STATUS ON<br>>> >> > CONNECTIONTYPE PLUGIN<br>>> >> > PLUGIN "msplugin_mssql2008.dll"<br>>> >> > CONNECTION "server=X;Integrated<br>
>> >> Security=false;database=X;uid=X;pwd=X"<br>>> >> > DATA "the_geom from viw USING UNIQUE oid USING SRID=0"<br>>> >> > CLASS<br>>> >> > TEMPLATE "template.html"<br>
>> >> > NAME "X"<br>>> >> > STYLE<br>>> >> > OUTLINECOLOR 150 150 150<br>>> >> > WIDTH 1<br>>> >> > END<br>>> >> > END<br>
>> >> > END<br>>> >> ><br>>> >> > Thanks<br>>> >> ><br>>> >> > Paul<br>>> >><br>>><br></div></div></blockquote></div><br>