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 behalf of Stephen Woodbridge [wood...@swoodbridge.com] Sent: Wednesday, January 04, 2017 8:53 AM To: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] variable substitution 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) > <joerg.thom...@wheregroup.com <mailto:joerg.thom...@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 <tel:+49%2030%20513027874> > Fax: +49 (0)30 / 89 09 53 21 <tel:+49%2030%2089095321> > > joerg.thom...@wheregroup.com <mailto:joerg.thom...@wheregroup.com> > www.wheregroup.com <http://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@lists.osgeo.org <mailto:mapserver-users@lists.osgeo.org> > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > > _______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users