<html><head></head><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1550119469217_521797">Thanks (again!! :-)</div><div id="yui_3_16_0_ym19_1_1550119469217_523534"><br></div><div id="yui_3_16_0_ym19_1_1550119469217_523536">I'm trying to get runtime variable substitution working, without success.<br></div><div id="yui_3_16_0_ym19_1_1550119469217_523522"><br></div><div id="yui_3_16_0_ym19_1_1550119469217_523506">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...<br></div><div id="yui_3_16_0_ym19_1_1550119469217_523118"><br></div><div id="yui_3_16_0_ym19_1_1550119469217_521830">The URL I'm using to test the service:</div><div id="yui_3_16_0_ym19_1_1550119469217_521831" dir="ltr"><i id="yui_3_16_0_ym19_1_1550119469217_521861">localhost/cgi-bin/mapserv?map=trawl.map&species_code=RCO&version=2.0.0&srsname=EPSG:4326&typename=Selected_Species&service=wfs&request=getfeature</i></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_521856"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_521857">The layer DATA statement:</div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_521872"> 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"<br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523087"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523149">The layer VALIDATION statement:</div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523158"> <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><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523150"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523088">The XML returned says: <br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523100"><i id="yui_3_16_0_ym19_1_1550119469217_523116">... numberMatched="0" numberReturned="0" ...<br></i></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523229"><i id="yui_3_16_0_ym19_1_1550119469217_523116"><br></i></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523230">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...<i id="yui_3_16_0_ym19_1_1550119469217_523256"><br></i></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523296"><i id="yui_3_16_0_ym19_1_1550119469217_523256">... numberMatched="7505" numberReturned="7505" ...<br></i></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523302"><i id="yui_3_16_0_ym19_1_1550119469217_523256"><br></i></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523572">The mapserver log (when trying substitution):</div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523573"><i id="yui_3_16_0_ym19_1_1550119469217_523256">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.<br id="yui_3_16_0_ym19_1_1550119469217_523581"><br></i></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523471"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523470">Can anyone suggest why my substitution is failing?<i id="yui_3_16_0_ym19_1_1550119469217_523256"><br></i></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523475"><i id="yui_3_16_0_ym19_1_1550119469217_523256"><br></i></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523675">Thanks,</div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523676"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523677">Brent Wood<i id="yui_3_16_0_ym19_1_1550119469217_523256"><br></i></div><div dir="ltr" id="yui_3_16_0_ym19_1_1550119469217_523476"><i id="yui_3_16_0_ym19_1_1550119469217_523256"><br></i></div><div dir="ltr"><i id="yui_3_16_0_ym19_1_1550119469217_523256"><br></i></div></div></body></html>