[Cartoweb-users] Mapfile Expression NULL value

[Pierre GIRAUD]

Don't know if this will work but have a try at :

EXPRESSION ('[tx_femme]' = 'NULL')

In the case you have several classes and the last one with no particular 
expression to parse, try for this class :

EXPRESSION /_always_false_/

Regards

Pierre

Emmanuel BELO wrote:

> Hi,
>
> How do you handle NULL values from you database in your mapfile's 
> expression?
>
> Example (NULL value for some tx_femme):
>
>  CLASS
>     EXPRESSION (([tx_femme] > 8) AND ([tx_femme] <= 15))
>     NAME "8 - 15"
>     STYLE
>       COLOR 255 217 0
>     END
>   END
>
> Doing nothing leads to this error message:
>
> Failure
>
> class:   SoapFaultWrapper
> message:   Mapserver error: Error in msEvalExpression: Failed to parse 
> expression
>
> Error in msyyparse(): syntax error
>
> Error in msEvalExpression: Failed to parse expression
>
> Error in msyyparse(): syntax error
>
> Error in msEvalExpression: Failed to parse expression
>
> Error in msyyparse(): syntax error
>
> Error in msEvalExpression: Failed to parse expression
>
> Error in msyyparse(): syntax error
>
> Error in msEvalExpression: Failed to parse expression
>
> Error in msyyparse(): syntax error
>
>
>
> Best regards,
>
> Emmanuel BELO
>
>_______________________________________________
>Cartoweb-users mailing list
>Cartoweb-users at lists.maptools.org
>http://lists.maptools.org/mailman/listinfo/cartoweb-users
>  
>


-- 
_________________________________________________________
Pierre GIRAUD
Géomaticien, Analyste

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac, Cedex 

Tel : 00 33 4 79 44 44 93
Mail : pierre.giraud at camptocamp.com
http://www.camptocamp.com