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

2011-07-13 Thread pcreso
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 wrote: From: Julien Cigar Subject: [mapserver-users] subs

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

2011-07-13 Thread Stephen Woodbridge
On 7/13/2011 9:59 AM, Julien Cigar wrote: On 07/13/2011 15:38, Rahkonen Jukka wrote: Julien Cigar wrote: This may be a stupid question but: is there a reason why PQescapeStringConn() is not used to do the substitution? Perhaps because Mapserver does not support just PostgreSQL but also Oracl

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

2011-07-13 Thread Julien Cigar
On 07/13/2011 15:38, Rahkonen Jukka wrote: Julien Cigar wrote: This may be a stupid question but: is there a reason why PQescapeStringConn() is not used to do the substitution? Perhaps because Mapserver does not support just PostgreSQL but also Oracle, SQL Server, MySQL, Informix, CouchDB e

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

2011-07-13 Thread Rahkonen Jukka
Julien Cigar wrote: > This may be a stupid question but: is there a reason why > PQescapeStringConn() is not used to do the substitution? Perhaps because Mapserver does not support just PostgreSQL but also Oracle, SQL Server, MySQL, Informix, CouchDB etc. Therefore it is good to have some gen

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

2011-07-13 Thread Julien Cigar
On 07/13/2011 15:07, Daniel Morissette wrote: On 11-07-13 08:41 AM, Julien Cigar wrote: OK.. I missed the "(must validate against DATAPATTERN)" part. I added "SPID_validation_pattern" "^[0-9]+$" in my METADATA and it works ! However, it looks a little "hackish" to me .. I wondered if Mapserver

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

2011-07-13 Thread Daniel Morissette
On 11-07-13 08:41 AM, Julien Cigar wrote: OK.. I missed the "(must validate against DATAPATTERN)" part. I added "SPID_validation_pattern" "^[0-9]+$" in my METADATA and it works ! However, it looks a little "hackish" to me .. I wondered if Mapserver uses PQescapeStringConn() in background? In ot

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

2011-07-13 Thread Julien Cigar
OK.. I missed the "(must validate against DATAPATTERN)" part. I added "SPID_validation_pattern" "^[0-9]+$" in my METADATA and it works ! However, it looks a little "hackish" to me .. I wondered if Mapserver uses PQescapeStringConn() in background? In other words: is _validation_pattern the onl

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

2011-07-13 Thread Julien Cigar
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