[Mapguide-trac] [mapguide-trac] #2574: postgis/mssql datetime properties in properties panel show as null

[MapGuide Open Source]

#2574: postgis/mssql datetime properties in properties panel show as null
-------------------------+-------------------------------
   Reporter:  Jamo       |      Owner:
       Type:  defect     |     Status:  new
   Priority:  low        |  Milestone:
  Component:  Map Agent  |    Version:  3.0.0
   Severity:  trivial    |   Keywords:  PostGis, MapAgent
External ID:             |
-------------------------+-------------------------------
 Upon selecting a feature with a postgis dateTime value the dateTime value
 is returned as null to the selection panel from the map agent.

 PostGis Table:

 {{{
 -- Table: gisgeom.plndevapp

 -- DROP TABLE gisgeom.plndevapp;

 CREATE TABLE gisgeom.plndevapp
 (
   fid bigserial NOT NULL,
   xfmuuid character varying,
   id character varying(255),
   landuse character varying(255),
   approved_dt timestamp without time zone,
   supportingfiles text,
   geom geometry,
   CONSTRAINT plndevapp_pkey PRIMARY KEY (fid),
   CONSTRAINT enforce_dims_geom CHECK (st_ndims(geom) = 2),
   CONSTRAINT enforce_srid_geom CHECK (st_srid(geom) = 28356)
 )
 WITH (
   OIDS=FALSE
 );
 ALTER TABLE gisgeom.plndevapp
   OWNER TO "GIS_ADMIN";
 }}}

 single data row

 {{{
 INSERT INTO gisgeom.plndevapp(
             fid, xfmuuid, id, landuse, approved_dt, supportingfiles, geom)
     VALUES (76,"","DP26-12","BRISBANE CONTAINER TERMINALS AMENDMENTS TO
 DP10-11","2012-11-20
 10:36:27","<supportingFiles><file><file>A1805411</file><fileType>objective</fileType><status></status><comment>Consent
 Notice</comment></file><file><file>fA237425</file><fileType>objective</fileType><status></status><comment>Consent
 Notice</comment></file></supportingFiles>","0101000020C46E00002D06141A4C9C1F41D7DC34DA159A5A41");
 }}}


 Discussion on nabble: [http://osgeo-org.1560.x6.nabble.com/Mapguide-3-0
 -and-postgis-mssql-datetime-properties-td5229375.html]

--
Ticket URL: <https://trac.osgeo.org/mapguide/ticket/2574>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals