<font size=2 face="sans-serif">this is weird.....</font>
<br><font size=2 face="sans-serif">First, DescribeFeatureType returns string
for every attributes</font>
<br><font size=2 color=#2f2f2f face="Arial"><element name="LONG_STAT" minOccurs="0" type="string"/></font><font size=3>
</font>
<br>
<br><font size=2 face="sans-serif">Here is a getfeature response ( </font><a href="http://www.google.com/url?q=http%3A%2F%2Fmapdev1.fadq.qc%2Fwfs%3FSERVICE%3DWFS%26VERSION%3D1.1.0%26REQUEST%3DGetFeature%26TYPENAME%3Dfeature%3ASMDVDP_STAT_METE%26maxFeatures%3D5&sa=D&sntz=1&usg=AFQjCNFDqeJtWaVVo73CNS37fk_JC7qPWA" target=_blank><font size=2 color=blue face="Arial"><u>http:/xxxxx?SERVICE=WFS&VERSION=1.1.0&REQUEST=GetFeature&TYPENAME=feature:SMDVDP_STAT_METE&maxFeatures=5</u></font></a><font size=2 face="sans-serif">
) </font>
<br><font size=2 color=#2f2f2f face="Arial"> <ms:LONG_STAT>-65</font><font size=2 color=red face="Arial"><b>,</b></font><font size=2 color=#2f2f2f face="Arial">6906</ms:LONG_STAT>
</font><font size=3> </font>
<br>
<br><font size=2 face="sans-serif">Using </font><font size=2 color=#2f2f2f face="Arial">ogc:PropertyIsEqualTo
matchCase="true"</font><font size=3> </font><font size=2 color=#2f2f2f face="Arial"><ogc:Literal>-61</font><font size=2 color=red face="Arial"><b>,</b></font><font size=2 color=#2f2f2f face="Arial">8031</ogc:Literal></font><font size=3>
it crashes</font>
<br><font size=2 face="sans-serif">Using </font><font size=2 color=#2f2f2f face="Arial">ogc:PropertyIsEqualTo
matchCase="true"</font><font size=3> </font><font size=2 color=#2f2f2f face="Arial"><ogc:Literal>-61</font><font size=2 color=red face="Arial"><b>.</b></font><font size=2 color=#2f2f2f face="Arial">8031</ogc:Literal></font><font size=3>
it works</font>
<br><font size=2 face="sans-serif">Using </font><font size=2 color=#2f2f2f face="Arial">ogc:PropertyIsEqualTo
matchCase="false"</font><font size=3> </font><font size=2 color=#2f2f2f face="Arial"><ogc:Literal>-61</font><font size=2 color=red face="Arial"><b>.</b></font><font size=2 color=#2f2f2f face="Arial">8031</ogc:Literal></font><font size=3>
it crashes</font>
<br>
<br><font size=3>So getfeature returns "," as decimals separator,
but getfeature with a filter needs a "." to works, but with matchCase=false
crashes in any case.....</font>
<br>
<br><font size=3>I'm totally confuse</font>
<p>
<br>
<br>
<br>
<table width=100% style="border-collapse:collapse;">
<tr valign=top height=8>
<td width=40% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size=1 face="sans-serif"><b>"Rahkonen
Jukka (MML)" <jukka.rahkonen@maanmittauslaitos.fi></b> </font>
<p><font size=1 face="sans-serif">2015-05-13 10:46</font>
<td width=59% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<table width=100% style="border-collapse:collapse;">
<tr valign=top height=21>
<td width=57 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align=right><font size=1 face="sans-serif">A</font></div>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size=1 face="sans-serif">"Steve.Toutant@inspq.qc.ca"
<Steve.Toutant@inspq.qc.ca></font>
<tr valign=top height=21>
<td width=57 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size=1 face="sans-serif">MapserverList
OSGEO <mapserver-users@lists.osgeo.org></font>
<tr valign=top height=21>
<td width=57 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align=right><font size=1 face="sans-serif">Objet</font></div>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size=1 face="sans-serif">VS:
[mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric
field</font></table>
<br>
<table width=393 style="border-collapse:collapse;">
<tr valign=top height=8>
<td width=57 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<td width=336 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"></table>
<br></table>
<br>
<br>
<br>
<br>
<br><font size=3 color=#004080 face="Calibri">Hi,</font>
<br><font size=3 color=#004080 face="Calibri"> </font>
<br><font size=3 color=#004080 face="Calibri">What does the schema of the
feature type show if you check it with DescribeFeatureType? If the property
is String I think you should stop what you do and make Mapserver to consider
and announce the property as numeric first.</font>
<br><font size=3 color=#004080 face="Calibri"> </font>
<br><font size=3 color=#004080 face="Calibri">-Jukka Rahkonen-</font>
<br><font size=3 color=#004080 face="Calibri"> </font>
<br><a href=mailto:Steve.Toutant@inspq.qc.ca><font size=3 color=blue face="Tahoma"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size=3 face="Tahoma">
wrote:</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Arial">this works</font><font size=3 face="Times New Roman">
</font><font size=3 color=#2f2f2f face="Arial"><br>
<ogc:PropertyIsLike matchCase="true" wildCard="*"
singleChar="." escapeChar="!"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>*-61,8031*</ogc:Literal></ogc:PropertyIsLike></font><font size=3 face="Times New Roman">
<br>
</font><font size=3 face="Arial"><br>
But we want to be able to usePropertyIsEqual because are end users won't
use PropertyIsLike...</font><font size=3 face="Times New Roman"> </font>
<p><font size=3 face="Times New Roman"><br>
</font>
<p>
<table width=100% style="border-collapse:collapse;">
<tr valign=top height=8>
<td width=35% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size=3 face="Arial"><b>thomas
bonfort <</b></font><a href=mailto:thomas.bonfort@gmail.com><font size=3 color=blue face="Arial"><b><u>thomas.bonfort@gmail.com</u></b></font></a><font size=3 face="Arial"><b>></b>
</font>
<p><font size=3 face="Arial">2015-05-13 05:40</font><font size=3 face="Times New Roman">
</font>
<td width=64% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<br>
<table width=100% style="border-collapse:collapse;">
<tr valign=top height=8>
<td width=8% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align=right><font size=3 face="Arial">A</font></div>
<td width=91% style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><a href=mailto:Steve.Toutant@inspq.qc.ca><font size=3 color=blue face="Arial"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size=3 face="Times New Roman">
</font>
<tr valign=top height=8>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align=right><font size=3 face="Arial">cc</font></div>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size=3 face="Arial">MapserverList
OSGEO <</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size=3 color=blue face="Arial"><u>mapserver-users@lists.osgeo.org</u></font></a><font size=3 face="Arial">></font><font size=3 face="Times New Roman">
</font>
<tr valign=top height=8>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align=right><font size=3 face="Arial">Objet</font></div>
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size=3 face="Arial">Re:
[mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric
field</font></table>
<br><font size=3 face="Times New Roman"> </font>
<p>
<br>
<table width=393 style="border-collapse:collapse;">
<tr valign=top height=8>
<td width=57 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<td width=336 style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"></table>
<br></table>
<p><font size=3 face="Times New Roman"><br>
<br>
<br>
<br>
</font><font size=3 face="Courier New"><br>
can you try the same request without the "matchCase" part and
report<br>
back please?<br>
<br>
On 12 May 2015 at 18:11, <</font><a href=mailto:Steve.Toutant@inspq.qc.ca><font size=3 color=blue face="Courier New"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size=3 face="Courier New">>
wrote:<br>
> I have a problem using a FILTER in a wfs getFeature request on an
oracle DB<br>
> with MS7<br>
> When I launch a getFeature request with a Filter on a numeric field
it<br>
> doesn't work,<br>
> <ogc:Filter xmlns:ogc="</font><a href=http://www.opengis.net/ogc><font size=3 color=blue face="Courier New"><u>http://www.opengis.net/ogc</u></font></a><font size=3 face="Courier New">"><ogc:PropertyIsEqualTo<br>
> matchCase="false"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>-61</ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter><br>
> here is the error we get in the browser<br>
> <ows:Exception exceptionCode="NoApplicableCode" locator="mapserv"><br>
> <ows:ExceptionText>msWFSGetFeature(): WFS server
error.<br>
> FLTApplyFilterToLayer() failed<br>
> msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your
data<br>
> statement and server logs</ows:ExceptionText><br>
><br>
> from mapserver logs<br>
> [Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter.<br>
> String: ([LONG_STAT] =*-61)<br>
><br>
> LONG_STAT is a NUMBER in the DB<br>
> DescribefeatureType returns<br>
> <element name="NO_STAT_CLIM"
minOccurs="0" type="string"/><br>
> <element name="NO_STAT_FADQ"
minOccurs="0" type="string"/><br>
> <element name="NOM_STAT"
minOccurs="0" type="string"/><br>
> <element name="LATI_STAT"
minOccurs="0" type="string"/><br>
> <element name="LONG_STAT"
minOccurs="0" type="string"/><br>
> <element name="ALTI_STAT"
minOccurs="0" type="string"/><br>
><br>
> I tried to add "gml_types" "auto" in the mapfile,
but it still returns<br>
> string as data type<br>
> I tried "gml_LONG_STAT_type" = "Integer" in the
mapfile, describeFeatureType<br>
> returns "<element name="LONG_STAT" minOccurs="0"
type="double"/> " but I<br>
> still get an error in getFeature<br>
><br>
> I'm using CONNECTIONTYPE oraclespatial in the mapfile<br>
><br>
> I can provide more information....<br>
><br>
> Is it a known issue or can I do something about that?<br>
><br>
> Thank you!<br>
> _______________________________________________<br>
> mapserver-users mailing list<br>
> </font><a href="mailto:mapserver-users@lists.osgeo.org"><font size=3 color=blue face="Courier New"><u>mapserver-users@lists.osgeo.org</u></font></a><font size=3 face="Courier New"><br>
> </font><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users"><font size=3 color=blue face="Courier New"><u>http://lists.osgeo.org/mailman/listinfo/mapserver-users</u></font></a><font size=3 face="Times New Roman"><br>
<br>
</font>
<br>
<br>
<br>