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 <[EMAIL PROTECTED]> 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
begin:vcard
fn:Emmanuel Belo
n:Belo;Emmanuel
org:MicroGIS SA
adr:;;ch. des Jordils 40;St-Sulpice;VD;1025;Switzerland
email;internet:[EMAIL PROTECTED]
title;quoted-printable:Ing=C3=A9nieur en g=C3=A9omatique
tel;work:+41 21 691 77 17
tel;fax:+41 21 691 77 86
x-mozilla-html:FALSE
url:http://www.microgis.ch
version:2.1
end:vcard
