[mapserver-users] variable substitution

2017-01-04 Thread WhereGroup
Hello and a happy new year! I have had some problems with variable subst. and the FILTER keyword, following the example from http://mapserver.org/cgi/runsub.html#filters I first tried > VALIDATION > 'adrkey' '[0-9]' > END > > FILTER ('gid=%adrkey%') but this does

Re: [mapserver-users] variable substitution

2017-01-04 Thread thomas bonfort
If you're using mapserver, your syntax and the docs probably need to be updated. Try: FILTER ( "[gid]" = "[%adrkey%]" ) please submit a PR to the docs if that solved the issue. -- thomas On Wed, Jan 4, 2017 at 12:27 PM Jörg Thomsen (WhereGroup) < joerg.thom...@wheregroup.com> wrote: > Hello an

Re: [mapserver-users] variable substitution

2017-01-04 Thread WhereGroup
Hello Thomas, Am 04.01.2017 um 12:34 schrieb thomas bonfort: > FILTER ( "[gid]" = "[%adrkey%]" ) this doesn't work, ms puts the value into quotes so PG interprets it as a column-name. > [Wed Jan 4 12:40:04 2017].714496 msPostGISLayerWhichShapes(): Error (ERROR: > column "2" does not exist > LI

Re: [mapserver-users] variable substitution

2017-01-04 Thread thomas bonfort
yeah, if you want an integer comparison use: FILTER ( [gid] = [%adrkey%] ) On Wed, Jan 4, 2017 at 12:43 PM Jörg Thomsen (WhereGroup) < joerg.thom...@wheregroup.com> wrote: > Hello Thomas, > > Am 04.01.2017 um 12:34 schrieb thomas bonfort: > > FILTER ( "[gid]" = "[%adrkey%]" ) > > this doesn't wo

[mapserver-users] Mapserver data point on map

2017-01-04 Thread newmapserver
Hello and happy new year ! Currently, I place points (lat / lon) on a map using a mysql query. At each point is associated an image according to the type of places considered. Today, I would like to retrieve my information either thanks to Mysql but thanks to an API. I use the function "addPoints

Re: [mapserver-users] variable substitution

2017-01-04 Thread Stephen Woodbridge
Or use: FILTER ( "[gid]" = '[%adrkey%]' ) " for the column name ' for the value -Steve W On 1/4/2017 6:47 AM, thomas bonfort wrote: yeah, if you want an integer comparison use: FILTER ( [gid] = [%adrkey%] ) On Wed, Jan 4, 2017 at 12:43 PM Jörg Thomsen (WhereGroup) mailto:joerg.thom...@whereg

Re: [mapserver-users] variable substitution

2017-01-04 Thread Lime, Steve D (MNIT)
Actually you don't want the []'s around the substitution as they denote a column reference. '%adrkey%' or %adrkey% should suffice depending on the type of comparison being done. --Steve From: mapserver-users [mapserver-users-boun...@lists.osgeo.org] on be

Re: [mapserver-users] Mapcache - Composite cache problem

2017-01-04 Thread tellett
Hi again and happy new year! I've tried what you suggested and managed to get the composite layer to work with this setup: /cache/mapcache/topo2 /cache/mapcache/topo2/{grid}/{z}/{x}/{y}.{ext} /cache/mapcache/topo2matrikkelsource /cache/mapcache/topo2matrikkelsou

[mapserver-users] Mapserver - libs in /usr/local/lib disappear after reboot

2017-01-04 Thread Ian Walberg
Folks, We build and install from source any of the recent versions using cmake. Then we copy the mapserv binary from /usr/local/bin to /var/www/cgi-bin to use with our apache install. All is good unless we reboot and the libs in /usr/local/lib are removed, this is a Fedora 19 server. Anyone k

Re: [mapserver-users] Mapserver - libs in /usr/local/lib disappear after reboot

2017-01-04 Thread Jeff McKenna
I haven't seen the libs-physically-disappear case, but I often reboot client servers and the libs 'cannot be found' (meaning executing mapserv doesn't search for the libs in the proper directory of /usr/local/lib/). In this case the solution is to set the LD_LIBRARY_PATH to that directory for

Re: [mapserver-users] Mapserver - libs in /usr/local/lib disappear after reboot

2017-01-04 Thread Ian Walberg
Jeff, Thanks for the info and you were correct, they had not disappeared. Karma - oops, my apologies. Regards Ian -Original Message- From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jeff McKenna Sent: Wednesday, January 4, 2017 11:32 AM To: mapserver

Re: [mapserver-users] variable substitution

2017-01-04 Thread Lime, Steve D (MNIT)
I should also add that you should add anchors (^$) to your validation expression. Just using "[0-9]" will match "111" but also "111; do something nasty in SQL". So "^[0-9]*$" is much better. Steve From: Lime, Steve D (MNIT) Sent: Wednesday, January 04, 2