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) <[email protected] <mailto:[email protected]>> 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> [email protected] <mailto:[email protected]> 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 [email protected] <mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
