[mapserver-users] Re: Getfeatureinfo and MSsql 2008 server

[Afroz K]

Dear Mr. Tamas,
 I have upgraded my Mapserver from 5.4.2 to 5.6.1 . I still get the same
message.

Layer 'region1'
Content-type: application/vnd.ogc.se_xml
<?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
<!DOCTYPE ServiceExceptionReport SYSTEM "
http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd">
<ServiceExceptionReport version="1.1.1">
<ServiceException>
</ServiceException>
</ServiceExceptionReport>

There are two notable changes after the upgrade

1. I no more get the error  "msMSSQL2008LayerGetShapeRandom bad shape: 1" in
the log file.
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.

SELECT convert(varchar(max), ID),convert(varchar(max),
name),convert(varchar(max),
flag1),convert(varchar(max), flag2),convert(varchar(max),
flag3),geom.STAsBinary(),convert(varchar(20), id) from region1
WHEREgeom.STIntersects(Geometry
::STGeomFromText('POLYGON((55.4843749962207
-4.59960928778372,56.5390624973545 -4.59960928778372,56.5390624973545
-3.54492178664993,55.4843749962207 -3.54492178664993,55.4843749962207
-4.59960928778372))',4326)) = 1

Thanks and regards
Afroz

On Mon, Mar 1, 2010 at 4:28 PM, <afrozk at gmail.com> wrote:

> Dear Tamaz,
> My mapserver version is 5.4.2 .
> I ll upgrade and let u know the results.
>
> Thnx a lot
> Afroz
>
> Sent from my BlackBerry® smartphone from du
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100302/f72ce0d4/attachment.html