[mapserver-users] substitution in a PostGIS layer .. ?

[pcreso at pcreso.com]

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 <jcigar at ulb.ac.be> wrote:

From: Julien Cigar <jcigar at ulb.ac.be>
Subject: [mapserver-users] substitution in a PostGIS layer .. ?
To: mapserver-users at lists.osgeo.org
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
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20110713/af71b0a5/attachment.htm>