Hi Julian, That should work, if you look at the species maps at http://www.marinebiodiversity.org.nz I do exactly that to substitute the selected species name into the SQL in the mapserver DATA statement to generate the WFS layer.
In this case the client application appends &spp=xxxxx to the query string instead of doing it in the cgi, but I have done the same thing in cgi's as well. Perhaps try it with a lower case variable name & see if that works? Cheers, Brent Wood --- On Thu, 7/14/11, Julien Cigar <[email protected]> wrote: From: Julien Cigar <[email protected]> Subject: [mapserver-users] substitution in a PostGIS layer .. ? To: [email protected] Date: Thursday, July 14, 2011, 12:29 AM Hello, I have the following mapfile: http://www.pastie.org/2206896 with the following SLD: http://www.pastie.org/2206902 (generated dynamically) I wondered how can I change the WHERE sp.id=%SPID% in the subselect (following a CGI parameter)? I read http://mapserver.org/cgi/runsub.html, and tried with %SPID% (by passwing &SPID=3 in my URL) but it doesn't seems to work ... any idea? Thanks, Julien -- No trees were killed in the creation of this message. However, many electrons were terribly inconvenienced. -----Inline Attachment Follows----- _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
