[mapserver-users] help passing runtime variables through cgi obfuscation script

[Rahkonen Jukka (MML)]

Hi,

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.

-Jukka Rahkonen-

Lähettäjä: mapserver-users <mapserver-users-bounces at lists.osgeo.org> Puolesta Brent Wood
Lähetetty: maanantai 18. helmikuuta 2019 5.41
Vastaanottaja: mapserver-users at lists.osgeo.org
Aihe: Re: [mapserver-users] help passing runtime variables through cgi obfuscation script

Thanks (again!! :-)

I'm trying to get runtime variable substitution working, without success.

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...

The URL I'm using to test the service:
localhost/cgi-bin/mapserv?map=trawl.map&species_code=RCO&version=2.0.0&srsname=EPSG:4326&typename=Selected_Species&service=wfs&request=getfeature

The layer DATA statement:
 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"

The layer VALIDATION statement:
    VALIDATION
       #  spp code value is a 3 char upper case string
       'spp_code' '[A-Z][A-Z][A-Z]'
    END

The XML returned says:
... numberMatched="0" numberReturned="0" ...

If I edit the data statement to: where c.species='RCO' (ie: hard code the value to RCO rather than pass it in - no other change) I get the desired response...
... numberMatched="7505" numberReturned="7505" ...

The mapserver log (when trying substitution):
msPostGISLayerGetExtent(): General error message. msPostGISLayerGetExtent: Null result returned.
msQueryByRect(): Search returned no results. No matching record(s) found.

Can anyone suggest why my substitution is failing?

Thanks,

Brent Wood


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20190218/f79c0054/attachment-0001.html>