Hi, You've probably run into the same problem which I've already fixed (in trunk and branch-5-4) 2 days ago. For more details see:
http://trac.osgeo.org/mapserver/ticket/3082 Windows binary packages (containing the fix) can be downloaded at: http://vbkto.dyndns.org:1280/sdk/Default.aspx Best regards, Tamas 2009/8/12 D Boyd <[email protected]> > > Hi folks, > > I'm having a little trouble creating a WFS that takes data from a MS SQL > 2008 database. I have a table that stores points of interest, the table has > a unique field (PointID) and a geometry field (PointPos) that stores the > location. > > Previously I created a WMS that serves a map with these points drawn on > which worked fine, with the WFS however none of the points are being > returned in the feature collection. The following is displayed in the error > log: > > Wed Aug 12 15:55:11 2009].450000 in msMSSQL2008LayerGetItems (find column > names) > [Wed Aug 12 15:55:11 2009].450000 msMSSQL2008LayerInitItemInfo called > [Wed Aug 12 15:55:11 2009].450000 msMSSQL2008LayerGetShape called for > record > = 1 > [Wed Aug 12 15:55:11 2009].450000 msMSSQL2008LayerGetShape: select > convert(varchar(max), PointID),convert(varchar(max), > PointIdentifier),convert(varchar(max), PointDate),convert(varchar(max), > PointClass),convert(varchar(max), PointSubClass),PointPos from Points where > PointID = 1 > [Wed Aug 12 15:55:11 2009].450000 msMSSQL2008LayerGetShapeRandom bad shape: > 1 > [Wed Aug 12 15:55:11 2009].450000 mapserv request processing time > (msLoadMap > not incl.): 0.372s > > The getshape query in is returning the correct row with the PointPos in hex > (tested SQL managment studio). > > The layer is as follows: > > LAYER > NAME "PointData" > DEBUG 5 > > METADATA > wfs_title "Point data test" > gml_featureID "PointID" > wfs_version "1.0.0" > wfs_typename "PointData" > END > > CONNECTIONTYPE PLUGIN > TYPE POINT > PLUGIN "C:/mapserver/msplugin_mssql2008.dll" > CONNECTION "sql connection string" > DATA "PointPos FROM Points" > > STATUS ON > > PROJECTION > "init=epsg:27700" > END > DUMP TRUE > > CLASS > STYLE > COLOR 0 0 255 > END > END > END > > Any help with this issue would be greatly apreciated! > > > > -- > View this message in context: > http://n2.nabble.com/WFS%3A-msMSSQL2008LayerGetShapeRandom-bad-shape%3A-1-tp3431353p3431353.html > Sent from the Mapserver - User mailing list archive at Nabble.com. > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users >
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
