Mapfile Expression NULL value

[Emmanuel BELO]

Hi Steve, thank you for your answer but with PostgreSQL/PostGIS it 
doesn't work.

For now, the solution is to add a WHERE clause in the SQL statement:

  WHERE tx_femme IS NOT NULL

best regards,

eb

Steve Lime wrote:
> It really depends on how your datastore coughs up the data. I don't believe
> there is a true NULL with DBF files but I may be wrong. You might try 
> expressions like:
> 
>   EXPRESSION (not '[tx_femme]')
>   EXPRESSION ('[tx_femme]' = '')
> 
> Steve
> 
>>>> Emmanuel BELO <emmanuel.belo at MICROGIS.CH> 03/06/06 9:11 AM >>>
> 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
> 
> I've tried:
> 
> EXPRESSION ('[tx_femme]' = 'NULL')
> 
> EXPRESSION /_always_false_/
> 
> Best regards,
> 
> Emmanuel BELO
> 
> 
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: emmanuel.belo.vcf
Type: text/x-vcard
Size: 337 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060307/ba411d3c/attachment.vcf>