<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle20
{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:8.5in 11.0in;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
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="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">What data type is the “something” column in your case? I’ll whip up a quick test and see what the translated SQL looks like. --Steve<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Karin Kuipers [mailto:Karin.Kuipers@kartverket.no]
<br>
<b>Sent:</b> Thursday, December 20, 2018 1:11 AM<br>
<b>To:</b> Lime, Steve D (MNIT) <steve.lime@state.mn.us>; mapserver-dev@lists.osgeo.org<br>
<b>Subject:</b> SV: Boolean class expression Mapserver 7.2<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Hi Steve,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">“</span><span style="color:black">you’re saying you have data where something = ‘f’ and it works in 7.0 but not in 7.2”</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">That is indeed what I am trying to say.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">The portgis data is ‘true’ or ‘false’ (data type boolean) in Mapserver we query this with ‘t’ and ‘f’
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I have a WMS build in 7.0 with the == ‘f’ expression<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">We want to upgrade to 7.2 and during testing the layer with ==’f’ expression fail<a name="_MailEndCompose">s.</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">When changing the expression to != ‘t’ the layer works again.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">With kind regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Karin<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>Fra:</b> Lime, Steve D (MNIT) [<a href="mailto:steve.lime@state.mn.us">mailto:steve.lime@state.mn.us</a>]
<br>
<b>Sendt:</b> 19. desember 2018 16:55<br>
<b>Til:</b> Karin Kuipers <<a href="mailto:Karin.Kuipers@kartverket.no">Karin.Kuipers@kartverket.no</a>>;
<a href="mailto:mapserver-dev@lists.osgeo.org">mapserver-dev@lists.osgeo.org</a><br>
<b>Emne:</b> RE: Boolean class expression Mapserver 7.2<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:black">Hi Karin: All of the example expressions below represent straight string comparisons so for ("[something]" == 'f') to evaluate to true the value for something would need to be ‘f’, same goes for all the others.
‘f’, ‘t’ and ‘false’ are just strings and are not equivalent to true/false – you’d use something like ([something] == true) if you really wanted that type of comparison.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">Anyway, just so I understand, you’re saying you have data where something = ‘f’ and it works in 7.0 but not in 7.2?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black">--Steve<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> mapserver-dev [<a href="mailto:mapserver-dev-bounces@lists.osgeo.org">mailto:mapserver-dev-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Karin Kuipers<br>
<b>Sent:</b> Wednesday, December 19, 2018 3:03 AM<br>
<b>To:</b> <a href="mailto:mapserver-dev@lists.osgeo.org">mapserver-dev@lists.osgeo.org</a><br>
<b>Subject:</b> [mapserver-dev] Boolean class expression Mapserver 7.2<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Dear sir/madame,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I think I found an issue with the boolean class expression in Mapserver 7.2<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">On 7.0 ("[something]" == 'f') works<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">On 7.2 ("[something]" == 'f') does not work but ("[something]" != 't') works fine and ("[something]" == 'false') is fine as well.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Connection is to a postgis database. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="NO-BOK">With kind regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="NO-BOK"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="NO-BOK">Karin Kuipers<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="NO-BOK"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:3.0pt 3.0pt 3.0pt 3.0pt">
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<img border="0" width="111" height="70" id="Bilde_x0020_1" src="cid:image001.png@01D4984A.20B6F4D0" alt="logo_sign"><span lang="NO-BOK" style="font-size:12.0pt"><o:p></o:p></span></p>
</td>
<td width="100%" valign="top" style="width:100.0%;padding:3.0pt 3.0pt 3.0pt 3.0pt">
<p class="MsoNormal"><b><span lang="NO-BOK" style="font-size:7.0pt;font-family:"Verdana",sans-serif;color:#404040">Karin Kuipers</span></b><span lang="NO-BOK" style="font-size:7.0pt;font-family:"Verdana",sans-serif;color:#404040"><br>
Overingeniør GIS-Specialist<br>
IT-avdelingen, Geodatatjenester -I5 <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="NO-BOK" style="font-size:7.0pt;font-family:"Verdana",sans-serif;color:#404040">Tlf.: +47 </span><span style="font-size:7.0pt;font-family:"Verdana",sans-serif;color:#404040">321 13036 mob.:+47 46 213 198<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:7.0pt;font-family:"Verdana",sans-serif;color:#404040">E-post:
<a href="mailto:karin.kuipers@kartverket.no">karin.kuipers@kartverket.no</a> <o:p>
</o:p></span></p>
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:7.0pt;font-family:"Verdana",sans-serif;color:#404040"><br>
</span><span lang="NO-BOK" style="font-size:7.0pt;font-family:"Verdana",sans-serif;color:#404040">Tlf. sentralbord: 32 11 81 00<br>
Kundesenter: 08700 <br>
</span><span style="font-size:7.0pt;font-family:"Verdana",sans-serif;color:#404040"><a href="http://www.kartverket.no/"><span lang="NO-BOK" style="color:blue">www.kartverket.no</span></a></span><span lang="NO-BOK" style="font-size:7.0pt;font-family:"Verdana",sans-serif;color:#404040"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span lang="NO-BOK"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="NO-BOK"><o:p> </o:p></span></p>
</div>
</body>
</html>