On issue one, what version are you using? MapServer shouldn't be rounding the value. The comparison should be being done as a double. It might be helpful to see a sample dataset although if this is SDE I can't test on my end. One thing to try to help diagnose the problem would be to create a sample mapfile that draws your layer and uses the area attribute for labeling. What shows up for labels?
Steve Sent from my iPad On Jul 15, 2011, at 5:14 AM, Mario Franco <mario.fra...@ydreams.com> wrote: > Hi, > > I having two issues with mapserver if anyone can help me I would be > appreciated. > > The first has to do with an Expression in a class: > > I have a shape with an attribute with the 172060.0937 but when add to the > class: > >> EXPRESSION ( [AREA] = 172060.0937 ) > > The problem is that this expression returns false because mapserver is > rounding the double value from the database. If I compare with: > >> EXPRESSION ( [AREA] = 172060) > > it works. There is any way to turn this off or to increase the precision? > > > > The second issue is: > > I'm using this url > (http://localhost:82/cgi-bin/mapserv.exe?map=D%3a\projects\Inag\InterSIG+II\InterSIG+Website\Trunk\InterSIG+ASP.NET\Maps%2fintersig_281.map&qlayer=Concelhos&layers=Concelhos&MAPSIZE=629%20467&MINX=-232614.525612302&MINY=-49761.6088409424&MAXX=676601.080299802&MAXY=625284&mode=NQUERY&MAPSHAPE=POLYGON%28%28-232614%20-49761,%20-232614%20625284,%20676601%20625284,%20676601%20-49761,%20-232614%20-49761%29%29) > to execute a nquery but I always get the error "msSDELayerGetShape(): SDE > error. SE_stream_fetch_row(): Invalid parameter value passed to function. > (-66) " > > The log doesn't help that much: > >> [Fri Jul 15 10:47:19 2011].20000 msSDELayerOpen(): Layer Concelhos opened >> from scratch. >> [Fri Jul 15 10:47:23 2011].35000 >> msConnPoolRegister(Concelhos,ydinag2,port:5151,sde,sde,sde,01D6BCC0) >> [Fri Jul 15 10:47:23 2011].35000 msSDELayerOpen(): Layer Concelhos specified >> version SDE.DEFAULT. >> [Fri Jul 15 10:47:23 2011].42000 msSDEGetLayerInfo(): Looking for layer by >> SDE.CONCELH_PTCONT_2008_0_596, SHAPE, ydinag2,port:5151,sde,sde,sde >> [Fri Jul 15 10:47:23 2011].42000 msSDEGetLayerInfo(): No cached layerid >> found. >> [Fri Jul 15 10:47:23 2011].63000 msSDELCacheAdd(): Caching id for >> SDE.CONCELH_PTCONT_2008_0_596, SHAPE, ydinag2,port:5151,sde,sde,sde >> [Fri Jul 15 10:47:23 2011].72000 Getting all column information in >> msSDELayerInitItemInfo >> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for >> DICO >> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for >> CONCELHO >> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for >> DI >> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for >> DISTRITO >> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for >> CCDR >> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for >> NUT3 >> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for >> NUT3_NOME >> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for >> NUT2 >> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for >> NUT2_NOME >> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for >> AREA2008_1 >> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for >> objectid >> [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for >> SHAPE >> [Fri Jul 15 10:47:23 2011].79000 Column information has already been >> gotten... returning from msSDELayerInitItemInfo >> [Fri Jul 15 10:47:43 2011].122000 msSDELayerGetShape(): SDE error. >> SE_stream_fetch_row(): Invalid parameter value passed to function. (-66) >> [Fri Jul 15 10:47:43 2011].126000 msFreeMap(): freeing map at 01D3EFE8. >> [Fri Jul 15 10:47:43 2011].126000 msSDELayerCloseConnection(): Closing >> connection for layer Concelhos. >> [Fri Jul 15 10:47:43 2011].126000 >> msConnPoolRelease(Concelhos,ydinag2,port:5151,sde,sde,sde,01D6BCC0) >> [Fri Jul 15 10:47:43 2011].126000 >> msConnPoolClose(ydinag2,port:5151,sde,sde,sde,01D6BCC0) >> [Fri Jul 15 10:47:43 2011].156000 msSDELayerClose(): Closing layer Concelhos. >> [Fri Jul 15 10:47:43 2011].156000 >> msConnPoolRelease(Concelhos,ydinag2,port:5151,sde,sde,sde,00000000) >> [Fri Jul 15 10:47:43 2011].156000 msConnPoolRelease(): Unable to find handle >> for layer 'Concelhos'. >> [Fri Jul 15 10:47:43 2011].156000 msConnPoolRelease(): General error >> message. Unable to find handle for layer 'Concelhos'. > > > Here part of my configuration: >> LAYER >> NAME "Concelhos" >> METADATA >> "wms_title" "Concelhos" # required >> "wfs_title" "Concelhos" # required >> "gml_featureid" "ID" ## REQUIRED >> "gml_geometries" "geom" >> "gml_geom_type" "polygon" >> "gml_include_items" "all" # Optional (serves all >> attributes for layer) >> "gml_exclude_items" "GEOMETRY,OBJECTID" >> "ows_include_items" "all" >> "ows_exclude_items" "GEOMETRY,OBJECTID" >> END >> DUMP true >> TOLERANCE 10 >> TOLERANCEUNITS meters >> >> TYPE polygon >> >> #CONNECTIONTYPE SDE >> CONNECTIONTYPE PLUGIN >> PLUGIN "D:/ms4w/Apache/specialplugins/msplugin_sde_92.dll" >> CONNECTION "ydinag2,port:5151,sde,sde,sde" >> >> DATA "SDE.CONCELH_PTCONT_2008_0_596,SHAPE,SDE.DEFAULT" >> >> PROJECTION >> "init=EPSG:3763" #--sistema de coordenadas desta layer na origem >> END >> >> STATUS ON >> OPACITY 100 >> TEMPLATE '../Templates/Identify/t.html' > > I'm using Mapserver 5.6.3, I know it's not the latest but I didn't updated > yet. > > Any help would be useful and thx in advance. > > Mário Franco > > _______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users