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