[Mapserver-users] Class logical expression - date comparison
Nelson Luna Silvestre
nls at myrealbox.com
Wed Dec 4 14:12:08 EST 2002
Unfortunately that's not good news because I'm lacking the time to learn
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
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...
From: mapserver-users-admin at lists.gis.umn.edu
[mailto:mapserver-users-admin at lists.gis.umn.edu]On Behalf Of Vinko
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
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
> The problem is not being able to get a valid result from
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>
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
More information about the mapserver-users