[Mapserver-users] Class logical expression - date comparison

[Nelson Luna Silvestre]

8(

Unfortunately that's not good news because I'm lacking the time to learn
another software.

Anyway... it seems quite a flaw not being able to query a date datatype
field with mapserver.
Is it a mapserver limitation or an incompability with the shapefile's
format?

Well, I think that I'll have to add a long integer field on my shapefiles
and fill it with the number of days counted from 1-1-1900 to the date in
question - it's not a bright solution but will do.

Let's wait to see if there are any other sugestions...

-----Original Message-----
From: mapserver-users-admin at lists.gis.umn.edu
[mailto:mapserver-users-admin at lists.gis.umn.edu]On Behalf Of Vinko
Vrsalovic
Sent: quarta-feira, 4 de Dezembro de 2002 19:59
To: Nelson Luna Silvestre
Cc: vinko at cprsig.cl; mapserver-users at lists.gis.umn.edu
Subject: Re: [Mapserver-users] Class logical expression - date
comparison


On Wed, Dec 04, 2002 at 05:48:07PM -0000, Nelson Luna Silvestre wrote:
> Ok, ok... Maybe I didn't explained me right.
>
> My goal is to do a numeric/date comparison in a date field.
> "('[DATE]'='01-01-2001')" evaluates the same way as
> "('[DATE]'eq'01-01-2001')".
> The problem is not being able to get a valid result from
> "('[DATE]'>'01-01-2001')"

I'm not sure if there's an easy way to do it through Mapserver accessing
shapefiles. You could try PostGIS and use a real date datatype, then you
can use standard SQL queries that support dates.

--
Vinko Vrsalovic <el[|- at -|]vinko.cl>
http://www.cprsig.cl
_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users