Query with dates in

[Roberto Bianconi]

Hi Frank,

I've now tried this:

       CLASS
       # 1
          SYMBOL "cross"
          EXPRESSION ([VALUE] > 50. and [VALUE] <= 75. and [BEGIN] < 3000)
          COLOR  70 255   0
          OUTLINECOLOR 0 0 0
       END

and this:

       CLASS
       # 1
          SYMBOL "cross"
          EXPRESSION ([VALUE] > 50. and [VALUE] <= 75. and [BEGIN] lt '3000')
          COLOR  70 255   0
          OUTLINECOLOR 0 0 0
       END

but stilI I don't get anything.


On Mon, 28 Feb 2005 15:40:53 -0500, Frank Warmerdam
<fwarmerdam at gmail.com> wrote:
> On Mon, 28 Feb 2005 21:30:53 +0100, Roberto Bianconi
> <roberto.bianconi at gmail.com> wrote:
> > Hi,
> >
> > I have a shp file where data in the dbf associated are rows like this
> > (field names in first row):
> >
> > CODE, BEGIN, END, VALUE
> > A1, 2002-10-03T09:30:00, 2002-10-04T09:30:00, 60.
> > A2, 2002-10-03T09:30:00, 2002-10-05T09:30:00, 60.
> >
> > Everything works if I just retrieve CODEs with:
> >
> > CLASS
> >           SYMBOL "cross"
> >           EXPRESSION ([VALUE] > 50. and [VALUE] <= 75.)
> >           COLOR  70 255   0
> >           OUTLINECOLOR 0 0 0
> >        END
> >
> > However, if I query on dates too, then nothing is retrieved:
> >
> > CLASS
> >           SYMBOL "cross"
> >           EXPRESSION ([VALUE] > 50. and [VALUE] <= 75. and [BEGIN] <
> > '2002-10-06T18:00:00')
> >           COLOR  70 255   0
> >           OUTLINECOLOR 0 0 0
> >        END
> >
> > I've also tried the '2002-10-06 09:30' format, but no way...
>
> Roberto,
>
> Steve would know better, but aren't expressions just evaluated as simple
> arithmetic comparisons when you use < or >?  Wouldn't
> '2002-10-06T18:00:00' just evaluate to the number 2002? In
> which case only records from before 2002 would be returned.
>
> If you want smart date handling I think you need to accomplish
> it somehow else.   I could be wrong about the issue of course.
>
> Best regards,
> --
> ---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | Geospatial Programmer for Rent
>