[mapserver-users] variable substitution

[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.thomsen at wheregroup.com> wrote:

> 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
> > LINE 1: select "beschriftung","gid","2",encode(ST_AsBinary(ST_Force2...
>
> But the Filteritem / Filter solution is ok.
>
> Viele Grüße,
> Jörg Thomsen
>
> --
>
> *********************************************************
> FOSS Academy Winterschule 2017
> 20.-24.03.2017 in Bonn
> Alles Wichtige zur Erstellung einer GDI in nur 5 Tagen!
> https://www.foss-academy.com/schulungstermine/kompaktkurs-winterschule
> *********************************************************
>
> -------------------------------
> Jörg Thomsen
> WhereGroup GmbH & Co. KG
> Gillweg 3
> 14193 Berlin
> Germany
>
> Fon: +49 (0)30 / 5130 278 74 <+49%2030%20513027874>
> Fax: +49 (0)30 / 89 09 53 21 <+49%2030%2089095321>
>
> joerg.thomsen at wheregroup.com
> www.wheregroup.com
> Amtsgericht Bonn, HRA 6788
> -------------------------------
> Komplementärin:
> WhereGroup Verwaltungs GmbH
> vertreten durch:
> Olaf Knopp, Peter Stamm
> -------------------------------
> Folgen Sie der WhereGroup auf twitter: http://twitter.com/WhereGroup_com
> _______________________________________________
> 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/20170104/cecccb22/attachment.html>