Class Expressions

[DjwStone]

I'm having difficulty setting up an EXPRESSION statement for a PostGIS layer.

The field being tested is a numeric representation of a date in YYYYMMDD
format so that ranges can be easily compared.

When the expression is (say):

EXPRESSION  ('[fieldname]' ge '15010101')

everything works fine; I get the correct number of hits. Similarly,

EXPRESSION  ('[fieldname]' le '16001231')

works as it should.

However, when I have:

EXPRESSION  ('[fieldname]' ge '15010101') and ('[fieldname]' le '16001231')

I get no hits although there should be some.

Has anyone else had similar problems?

Cheers,

Dave
--
View this message in context: http://www.nabble.com/Class-Expressions-t1607707.html#a4358498
Sent from the Mapserver - User forum at Nabble.com.