<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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<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:0cm;
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;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.Shkpostityyli18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 2.0cm 70.85pt 2.0cm;}
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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">I guess that you do not really test with &species_code=RCO if you have defined variable as spp_code, but I have to ask anyway.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">-Jukka Rahkonen-<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Lähettäjä:</b> mapserver-users <mapserver-users-bounces@lists.osgeo.org>
<b>Puolesta </b>Brent Wood<br>
<b>Lähetetty:</b> maanantai 18. helmikuuta 2019 5.41<br>
<b>Vastaanottaja:</b> mapserver-users@lists.osgeo.org<br>
<b>Aihe:</b> Re: [mapserver-users] help passing runtime variables through cgi obfuscation script<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div id="yui_3_16_0_ym19_1_1550119469217_521797">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">Thanks (again!! :-)<o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523534">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523536">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">I'm trying to get runtime variable substitution working, without success.<o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523522">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523506">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">I'm not getting an error message, but no data comes back... so the query is working OK, but the parameter substitution is nor happening...<o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523118">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_521830">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">The URL I'm using to test the service:<o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_521831">
<p class="MsoNormal" style="background:white"><i><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">localhost/cgi-bin/mapserv?map=trawl.map&species_code=RCO&version=2.0.0&srsname=EPSG:4326&typename=Selected_Species&service=wfs&request=getfeature</span></i><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_521856">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_521857">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">The layer DATA statement:<o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_521872">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"> DATA "startp from (select ROW_NUMBER() OVER (order by (t.trip_code, t.station_no)) as id, t.trip_code, t.station_no, species as code,
sci_name, com_name, initcap(family_sci)||' ('|| initcap(family_com)||')' as Family, c.weight, ST_Shift_longitude(t.startp) as startp from trawl.t_station t, rdb.species_master s, trawl.t_catch c where c.species='%species_code%' and s.code = c.species and t.trip_code
= c.trip_code and t.station_no=c.station_no ) as myquery using unique id using srid 4326"<o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523087">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523149">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">The layer VALIDATION statement:<o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523158">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">
<i id="yui_3_16_0_ym19_1_1550119469217_523214">VALIDATION <br id="yui_3_16_0_ym19_1_1550119469217_523188">
# spp code value is a 3 char upper case string<br id="yui_3_16_0_ym19_1_1550119469217_523189">
'spp_code' '[A-Z][A-Z][A-Z]'<br id="yui_3_16_0_ym19_1_1550119469217_523190">
END</i><o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523150">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523088">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">The XML returned says:
<o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523100">
<p class="MsoNormal" style="background:white"><i><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">... numberMatched="0" numberReturned="0" ...</span></i><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523229">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523230">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">If I edit the data statement to:
<i id="yui_3_16_0_ym19_1_1550119469217_523256">where c.species='RCO' </i>(ie: hard code the value to RCO rather than pass it in - no other change) I get the desired response...<o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523296">
<p class="MsoNormal" style="background:white"><i><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">... numberMatched="7505" numberReturned="7505" ...</span></i><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523302">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523572">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">The mapserver log (when trying substitution):<o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523573">
<p class="MsoNormal" style="margin-bottom:12.0pt;background:white"><i><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">msPostGISLayerGetExtent(): General error message. msPostGISLayerGetExtent: Null result returned.<br id="yui_3_16_0_ym19_1_1550119469217_523580">
msQueryByRect(): Search returned no results. No matching record(s) found.</span></i><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523471">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523470">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">Can anyone suggest why my substitution is failing?<o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523475">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523675">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">Thanks,<o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523676">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523677">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black">Brent Wood<o:p></o:p></span></p>
</div>
<div id="yui_3_16_0_ym19_1_1550119469217_523476">
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Verdana",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
</div>
</div>
</body>
</html>