<div dir="ltr"><div>Dear Mr. Tamas,</div>
<div> I have upgraded my Mapserver from 5.4.2 to 5.6.1 . I still get the same message. </div>
<div> </div>
<div>Layer 'region1' <br>Content-type: application/vnd.ogc.se_xml <br><?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?> <br><!DOCTYPE ServiceExceptionReport SYSTEM "<a href="http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd" rel="nofollow" target="_top" link="external">http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd</a>"> <br>
<ServiceExceptionReport version="1.1.1"> <br><ServiceException> <br></ServiceException> <br></ServiceExceptionReport> </div>
<div> </div>
<div>There are two notable changes after the upgrade</div>
<div> </div>
<div>1. I no more get the error "msMSSQL2008LayerGetShapeRandom bad shape: 1" in the log file. <br>2. The query coming to the SQL server has changed a bit now , though it gives me the correct result while running it on the query window.</div>
<div><font color="#0000ff" size="2"><font color="#0000ff" size="2"></font></font> </div>
<div><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">convert</font></font><font size="2">(varchar(max), ID),</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">convert</font></font><font size="2">(varchar(max), name),</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">convert</font></font><font size="2">(varchar(max), flag1),</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">convert</font></font><font size="2">(varchar(max), flag2),</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">convert</font></font><font size="2">(varchar(max), flag3),geom.STAsBinary(),</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">convert</font></font><font size="2">(varchar(20), id) </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">from</font></font><font size="2"> region1 </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHERE</font></font><font size="2"> geom.STIntersects(Geometry</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">::</font></font><font size="2">STGeomFromText(</font><font color="#ff0000" size="2"><font color="#ff0000" size="2">'POLYGON((55.4843749962207 -4.59960928778372,56.5390624973545 -4.59960928778372,56.5390624973545 -3.54492178664993,55.4843749962207 -3.54492178664993,55.4843749962207 -4.59960928778372))'</font></font><font size="2">,4326)) = 1 </font></div>
<div><br>Thanks and regards</div>
<div>Afroz<br><br></div>
<div class="gmail_quote">On Mon, Mar 1, 2010 at 4:28 PM, <span dir="ltr"><<a href="mailto:afrozk@gmail.com">afrozk@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Dear Tamaz, <br>My mapserver version is 5.4.2 .<br>I ll upgrade and let u know the results. <br><br>Thnx a lot<br>
Afroz
<div class="im">
<p>Sent from my BlackBerry® smartphone from du</p></div></blockquote></div></div>