In Mapserver it is possible to set a variable when connecting to postGIS. This way I have created an fill-in form where you can enter a postcode and then you get a result.
How can do this with putting a runtime variable in the Mapserver. Like this:
DATA "geom from (select t1.geom from schemaname.tablename t1 where t1.code = '%code%') as selectie using unique code using srid=28992"
In the html / openlayers script you can refer to what is between the % %.
Now I want to make a selection tool for querying a different schema and table. So you have an input where you fill in a schemaname and tablename and then you get a result from that table.
I thought that it would be something like this:
DATA "geom from (select t1.geom, from %schemaname%.%tablename%) as selectie using unique code using srid=28992"
Unfortunately this is not working. Does someone know whether this is possible and how I can make this work.