A solution is to set in the SQL statement a WHERE clause:
WHERE tx_femme IS NOT NULL
regards,
eb
Emmanuel BELO wrote:
Thank you Pierre,
but it doesn't work. If i find something, I'll let yo know,
regards,
eb
Pierre GIRAUD wrote:
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
[email protected]
http://lists.maptools.org/mailman/listinfo/cartoweb-users
------------------------------------------------------------------------
_______________________________________________
Cartoweb-users mailing list
[email protected]
http://lists.maptools.org/mailman/listinfo/cartoweb-users
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
_______________________________________________
Cartoweb-users mailing list
[email protected]
http://lists.maptools.org/mailman/listinfo/cartoweb-users
