[MapServer-users] NULL-EXPRESSION

[Seth G]

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 at 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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20250328/6c7b373a/attachment.htm>