Hi, Unfortunately, MapServer doesn't have a NULL type. The workaround is to create a database view or query that will set the NULL to a numeric value of your choosing, e.g. -1 and then use that value in the CLASS expressions.
Seth -- web:https://geographika.net & https://mapserverstudio.net mastodon: @geographika@mastodon.social On Fri, Mar 28, 2025, at 8:55 AM, Angelique Kroisl via MapServer-users wrote: > Hello, > I'm trying to create a class using the class item "gst." > The attribute in the database can only have three values (2000, 2100, and > <NULL>). > Unfortunately, I can't create the NULL EXPRESSION. > > I've already tried the following: > EXPRESSION IS NULL > > EXPRESSION "<NULL>" > > EXPRESSION <NULL> > > EXPRESSION EMPTY > > What is the correct syntax for this? > > > > > > Monatlich aktuelle Informationen Ihrer Stadtverwaltung in unserem Newsletter! > Newsletter Anmeldung > <https://www.stadt-koeln.de/service/onlinedienste/newsletter-anmeldung?para=allgemein> > > > > > > <https://www.stadt-koeln.de/leben-in-koeln/freizeit-natur-sport/veranstaltungskalender/lidl-final4-dhb-pokal> > _______________________________________________ > MapServer-users mailing list > MapServer-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapserver-users >
_______________________________________________ MapServer-users mailing list MapServer-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users
