sde getFeature on DATE fields

[Hallgren Johan E]

Hello

I have found something as I see as a BUG.

I use getFeature in MapScript on a layer with date-fields.

It does only appear on SDE layers and it's the row below that crash as
soon as I have a date-field in the table.
shapeObj oShapeObj =
oLayerObj.getFeature(oResultCacheMemberObj.shapeindex,
oResultCacheMemberObj.tileindex);

Now I found the problem.

In mapsde.c I changed the line:
#define MS_SDE_TIMEFMT "%T %m/%d/%Y"
to 
#define MS_SDE_TIMEFMT "%H:%M:%S %m/%d/%Y"

And then the problem was gone.

I use Visuals Studio 2005, and I can only guess that the %T is not
supported in that compiler.

I hope this can be changed in the mapsde.c-file.

Best Regards
Johan
___________________________________


Johan Hallgren
WM-data a LogicaCMG company 
Pelle Bergs backe 3
Box 1938, 791 19 Falun
Tel: 023-547 46 (int: +46-2354746)
Mobil: 070-588 44 28 (int: +46-705884428)
johan.e.hallgren at wmdata.com
http://www.wmdata.se

-----Original Message-----
From: Howard Butler [mailto:hobu at iastate.edu] 
Sent: den 11 april 2007 17:43
To: Hallgren Johan E
Subject: Re: [UMN_MAPSERVER-DEV] sde getFeature on DATE fields

Johan,

With current CVS, I am able to render dates as labels from an SDE 
server.  The mapsde.c code in HEAD has seen a significant reworking 
recently, although there is one pretty serious bug outstanding that I 
am expecting to get to 
<http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=2067>.  You should 
be able to drop in a copy of CVS HEAD's mapsde.c into your 4.10.1 
distribution and recompile if you wish to test.

Howard


At 04:18 AM 4/11/2007, you wrote:
>Hello
>
>I have a problem when using getFeature on date-fields.
>
>shapeObj oShapeObj = 
>oLayerObj.getFeature(oResultCacheMemberObj.shapeindex, 
>oResultCacheMemberObj.tileindex);
>
>The row will crash as soon as I have a date-field in the table. It's 
>only related to SDE layers.
>
>I have seen the problem in version 4.10.1 as well as in snapshots after
that.
>
>Any solution?
>
>/Johan
>
>
>___________________________________
>
>
>
>
>
>Johan Hallgren
>
>
>
>
>WM-data a LogicaCMG company
>Pelle Bergs backe 3
>Box 1938, 791 19 Falun
>Tel: 023-547 46 (int: +46-2354746)
>Mobil: 070-588 44 28 (int: +46-705884428)
>johan.e.hallgren<BLOCKED::mailto:johan.e.hallgren at wmdata.com>@wmdata.co
m
><BLOCKED::/exchweb/bin/redir.asp?URL=http://www.wmdata.se/>http://www.w
mdata.se
>