Hi, Without being a programmer I would like to see what would happen if this source file
https://github.com/mapserver/mapserver/blob/branch-7-0/maporaclespatial.c would be edited around line 571-573: cmd = "alter session set NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'"; by adding a new block for setting the decimal and thousands separators for output cmd = "alter session set NLS_NUMERIC_CHARACTERS='. '"; I am not sure of the right syntax. This one works with SQL*Plus and set decimal points and space for thousands separator. I think that thousands should be without separators but the command seems to require two inputs. -Jukka Rahkonen- Lähettäjä: [email protected] [mailto:[email protected]] Puolesta Lime, Steve D (MNIT) Lähetetty: 19. toukokuuta 2015 22:12 Vastaanottaja: [email protected]; MapserverList OSGEO Kopio: [email protected] Aihe: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field Is there somewhere in the capabilities response where a user would declare what decimal separators are supported? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of [email protected]<mailto:[email protected]> Sent: Tuesday, May 19, 2015 2:06 PM To: MapserverList OSGEO Cc: [email protected]<mailto:[email protected]> Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field It seems to be a bug isn't? Do you want me to open an issue? "Smith, Michael ERDC-RDE-CRREL-NH" <[email protected]<mailto:[email protected]>> 2015-05-19 12:24 A "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> cc "Rahkonen Jukka (MML)" <[email protected]<mailto:[email protected]>>, MapserverList OSGEO <[email protected]<mailto:[email protected]>> Objet Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field It looks like whats happening is that's being converted into 3 Tokens and the oracle driver converts it into a number + comma + number. The tokenizer is not treating that value as a single value. Mike From: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Tuesday, May 19, 2015 at 11:44 AM To: Michael Smith <[email protected]<mailto:[email protected]>> Cc: "Rahkonen Jukka (MML)" <[email protected]<mailto:[email protected]>>, MapserverList OSGEO <[email protected]<mailto:[email protected]>> Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field here is the mapserver log with <ogc:PropertyIsEqualTo matchCase="true"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>-61,8031</ogc:Literal></ogc:PropertyIsEqualTo> msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT ID, NO_STAT_CLIM, NO_STAT_FADQ, NOM_STAT, LATI_STAT, LONG_STAT, ALTI_STAT, D_DEB, D_FIN, TIMB_MAJ, USAG_MAJ, rownum, GEOM_POIN FROM (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM D_DEB) = 2014) WHERE ( LONG_STAT = -61.000000,8031.000000 ) AND SDO_FILTER( GEOM_POIN, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE' The problem is WHERE ( LONG_STAT = -61.000000,8031.000000 )
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
