<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
h2
{mso-style-priority:9;
mso-style-link:"Otsikko 2 Char";
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:18.0pt;
font-family:"Times New Roman","serif";
font-weight:bold;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Seliteteksti Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.Otsikko2Char
{mso-style-name:"Otsikko 2 Char";
mso-style-priority:9;
mso-style-link:"Otsikko 2";
font-weight:bold;}
span.SelitetekstiChar
{mso-style-name:"Seliteteksti Char";
mso-style-priority:99;
mso-style-link:Seliteteksti;
font-family:"Tahoma","sans-serif";}
span.Shkpostityyli21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Shkpostityyli22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.pl-s
{mso-style-name:pl-s;}
span.pl-pds
{mso-style-name:pl-pds;}
span.Shkpostityyli25
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="FI" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">By reading the GML 3 standard it for example defines that Real and Number are of type xsd:double, and following that path to
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><a href="http://books.xmlschemata.org/relaxng/ch19-77065.html">http://books.xmlschemata.org/relaxng/ch19-77065.html</a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US" style="font-size:18.0pt">Restrictions<o:p></o:p></span></b></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">The decimal separator is always a point (.), and no thousands separator may be used.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Same restrictions to xsd:decimal http://books.xmlschemata.org/relaxng/ch19-77057.html<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">So at least in WFS 1.1.0 with GML 3 numbers with comma as decimal separator are wrong and if Mapserver ever generates such GML it feels like a
bug for me.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">-Jukka Rahkonen-<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Smith, Michael ERDC-RDE-CRREL-NH wrote:<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black">Jukka,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black">The issue is not only the NLS format, which would govern the output and how the sql is interpreted, but there is also the issue of the lexer which is reading
the xml request. And that would have to change also. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black">Its also unclear to me if XML / WFS allows other characters as a decimal character. I've yet to find any xsd or guide docs that indicate one way or the other. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black">Mike<o:p></o:p></span></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black">----<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black">Michael Smith<o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black">US Army Corps<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black">Remote Sensing GIS/Center<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black"><a href="mailto:michael.smith@usace.army.mil">michael.smith@usace.army.mil</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black"><o:p> </o:p></span></p>
</div>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black"><o:p> </o:p></span></p>
</div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">From:
</span></b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">"Rahkonen Jukka (MML)" <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>><br>
<b>Date: </b>Tuesday, May 19, 2015 at 5:08 PM<br>
<b>To: </b>"Lime, Steve D (MNIT)" <<a href="mailto:Steve.Lime@state.mn.us">Steve.Lime@state.mn.us</a>>, "<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>" <<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>>, MapserverList
OSGEO <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>
<b>Cc: </b>"<a href="mailto:Michael.Smith@erdc.dren.mi">Michael.Smith@erdc.dren.mi</a>" <<a href="mailto:Michael.Smith@erdc.dren.mi">Michael.Smith@erdc.dren.mi</a>><br>
<b>Subject: </b>Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field<br>
<b>Resent-From: </b>Michael Smith <<a href="mailto:michael.smith@usace.army.mil">michael.smith@usace.army.mil</a>><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri","sans-serif";color:black"><o:p> </o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Hi,</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Without being a programmer I would like to see what would happen if this source file
</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><a href="https://github.com/mapserver/mapserver/blob/branch-7-0/maporaclespatial.c">https://github.com/mapserver/mapserver/blob/branch-7-0/maporaclespatial.c</a></span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">would be edited around line 571-573:</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">cmd = <span class="pl-pds">
"</span><span class="pl-s">alter session set NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'</span><span class="pl-pds">"</span>;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">by adding a new block for setting the decimal and thousands separators for output</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">cmd = <span class="pl-pds">
"</span><span class="pl-s">alter session set NLS_NUMERIC_CHARACTERS='. '”</span>;</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">I am not sure of the right syntax. This one works with SQL*Plus and set decimal points and space for thousands separator. I think that thousands should be without separators but the command seems to
require two inputs.</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">-Jukka Rahkonen-</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">Lähettäjä:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:black">
<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a> [<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</a>]
<b>Puolesta </b>Lime, Steve D (MNIT)<br>
<b>Lähetetty:</b> 19. toukokuuta 2015 22:12<br>
<b>Vastaanottaja:</b> <a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>; MapserverList OSGEO<br>
<b>Kopio:</b> <a href="mailto:Michael.Smith@erdc.dren.mi">Michael.Smith@erdc.dren.mi</a><br>
<b>Aihe:</b> Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Is there somewhere in the capabilities response where a user would declare what decimal separators are supported?
</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"><a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a>
[<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b><a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a><br>
<b>Sent:</b> Tuesday, May 19, 2015 2:06 PM<br>
<b>To:</b> MapserverList OSGEO<br>
<b>Cc:</b> <a href="mailto:Michael.Smith@erdc.dren.mi">Michael.Smith@erdc.dren.mi</a><br>
<b>Subject:</b> Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">It seems to be a bug isn't?</span><span lang="EN-US" style="color:black"><br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Do you want me to open an issue?</span><span style="color:black"><o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr style="height:6.0pt">
<td width="40%" valign="top" style="width:40.0%;padding:0cm 0cm 0cm 0cm;height:6.0pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">"Smith, Michael ERDC-RDE-CRREL-NH" <<a href="mailto:Michael.Smith@erdc.dren.mil">Michael.Smith@erdc.dren.mil</a>></span></b><o:p></o:p></p>
<p style="mso-line-height-alt:6.0pt"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">2015-05-19 12:24</span><o:p></o:p></p>
</td>
<td width="59%" valign="top" style="width:59.0%;padding:0cm 0cm 0cm 0cm;height:6.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr style="height:15.75pt">
<td width="57" valign="top" style="width:42.75pt;padding:0cm 0cm 0cm 0cm;height:15.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">A</span><o:p></o:p></p>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 0cm;height:15.75pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">"<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>" <<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>></span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.75pt">
<td width="57" valign="top" style="width:42.75pt;padding:0cm 0cm 0cm 0cm;height:15.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">cc</span><o:p></o:p></p>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 0cm;height:15.75pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">"Rahkonen Jukka (MML)" <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>>, MapserverList OSGEO <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>></span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.75pt">
<td width="57" valign="top" style="width:42.75pt;padding:0cm 0cm 0cm 0cm;height:15.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">Objet</span><o:p></o:p></p>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 0cm;height:15.75pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"> <o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="393" style="width:294.75pt;border-collapse:collapse">
<tbody>
<tr style="height:6.0pt">
<td width="57" valign="top" style="width:42.75pt;padding:0cm 0cm 0cm 0cm;height:6.0pt">
</td>
<td width="336" valign="top" style="width:252.0pt;padding:0cm 0cm 0cm 0cm;height:6.0pt">
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span lang="EN-US" style="color:black"><br>
<br>
<br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:black">It looks like whats happening is that’s being converted into 3 Tokens and the oracle driver converts it into a number + comma + number.
</span><span lang="EN-US" style="color:black"><br>
<br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:black">The tokenizer is not treating that value as a single value.
</span><span lang="EN-US" style="color:black"><br>
<br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:black">Mike</span><span lang="EN-US" style="color:black"><br>
<br>
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:black">From:
</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:black">"</span><span lang="EN-US" style="color:black"><a href="mailto:Steve.Toutant@inspq.qc.ca"><span style="font-size:10.0pt;font-family:"Calibri","sans-serif"">Steve.Toutant@inspq.qc.ca</span></a></span><span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:black">"
<</span><span lang="EN-US" style="color:black"><a href="mailto:Steve.Toutant@inspq.qc.ca"><span style="font-size:10.0pt;font-family:"Calibri","sans-serif"">Steve.Toutant@inspq.qc.ca</span></a></span><span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:black">><b><br>
Date: </b>Tuesday, May 19, 2015 at 11:44 AM<b><br>
To: </b>Michael Smith <</span><span lang="EN-US" style="color:black"><a href="mailto:michael.smith@erdc.dren.mil"><span style="font-size:10.0pt;font-family:"Calibri","sans-serif"">michael.smith@erdc.dren.mil</span></a></span><span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:black">><b><br>
Cc: </b>"Rahkonen Jukka (MML)" <</span><span lang="EN-US" style="color:black"><a href="mailto:jukka.rahkonen@maanmittauslaitos.fi"><span style="font-size:10.0pt;font-family:"Calibri","sans-serif"">jukka.rahkonen@maanmittauslaitos.fi</span></a></span><span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:black">>,
MapserverList OSGEO <</span><span lang="EN-US" style="color:black"><a href="mailto:mapserver-users@lists.osgeo.org"><span style="font-size:10.0pt;font-family:"Calibri","sans-serif"">mapserver-users@lists.osgeo.org</span></a></span><span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:black">><b><br>
Subject: </b>Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field</span><span lang="EN-US" style="color:black"><br>
<br>
</span><span lang="EN-US" style="font-family:"Calibri","sans-serif";color:#004080">here is the mapserver log with
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"><ogc:PropertyIsEqualTo matchCase="true"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>-61,8031</ogc:Literal></ogc:PropertyIsEqualTo></span><span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:black"><br>
</span><span lang="EN-US" style="font-family:"Calibri","sans-serif";color:#004080"><br>
msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT ID, NO_STAT_CLIM, NO_STAT_FADQ, NOM_STAT, LATI_STAT, LONG_STAT, ALTI_STAT, D_DEB, D_FIN, TIMB_MAJ, USAG_MAJ, rownum, GEOM_POIN FROM (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR
FROM D_DEB) = 2014) WHERE ( LONG_STAT = -61.000000,8031.000000 ) AND SDO_FILTER( GEOM_POIN, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:black"><br>
<br>
</span><span lang="EN-US" style="font-family:"Calibri","sans-serif";color:#004080"><br>
The problem is<br>
WHERE ( LONG_STAT = -61.000000,8031.000000 )</span><span lang="EN-US" style="color:black">
</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
</body>
</html>