<html><body bgcolor="#FFFFFF"><div>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?</div><div><br></div><div>Steve<br><br>Sent from my iPad</div><div><br>On Jul 15, 2011, at 5:14 AM, Mario Franco <<a href="mailto:mario.franco@ydreams.com">mario.franco@ydreams.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div>
Hi, <br>
<br>
I having two issues with mapserver if anyone can help me I would be
appreciated.<br>
<br>
The first has to do with an Expression in a class:<br>
<br>
I have a shape with an attribute with the 172060.0937 but when add
to the class:<br>
<br>
<blockquote type="cite"><small>EXPRESSION ( [AREA] = 172060.0937 )</small></blockquote>
<br>
The problem is that this expression returns false because mapserver
is rounding the double value from the database. If I compare with:<br>
<br>
<blockquote type="cite"><small>EXPRESSION ( [AREA] = 172060)</small></blockquote>
<br>
it works. There is any way to turn this off or to increase the
precision?<br>
<br>
<br>
<br>
The second issue is:<br>
<br>
I'm using this url (<small><a class="moz-txt-link-freetext" href="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"><a href="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">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</a></a></small>)
to execute a nquery but I always get the error
"msSDELayerGetShape(): SDE error. SE_stream_fetch_row(): Invalid
parameter value passed to function. (-66)
"<br>
<br>
The log doesn't help that much:<br>
<small><br>
</small>
<blockquote type="cite"><small>[Fri Jul 15 10:47:19 2011].20000
msSDELayerOpen(): Layer Concelhos opened from scratch.<br>
[Fri Jul 15 10:47:23 2011].35000
msConnPoolRegister(Concelhos,ydinag2,port:5151,sde,sde,sde,01D6BCC0)<br>
[Fri Jul 15 10:47:23 2011].35000 msSDELayerOpen(): Layer
Concelhos specified version SDE.DEFAULT.<br>
[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<br>
[Fri Jul 15 10:47:23 2011].42000 msSDEGetLayerInfo(): No cached
layerid found.<br>
[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<br>
[Fri Jul 15 10:47:23 2011].72000 Getting all column information
in msSDELayerInitItemInfo<br>
[Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo():
getting info for DICO<br>
[Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo():
getting info for CONCELHO<br>
[Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo():
getting info for DI<br>
[Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo():
getting info for DISTRITO<br>
[Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo():
getting info for CCDR<br>
[Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo():
getting info for NUT3<br>
[Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo():
getting info for NUT3_NOME<br>
[Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo():
getting info for NUT2<br>
[Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo():
getting info for NUT2_NOME<br>
[Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo():
getting info for AREA2008_1<br>
[Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo():
getting info for objectid<br>
[Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo():
getting info for SHAPE<br>
[Fri Jul 15 10:47:23 2011].79000 Column information has already
been gotten... returning from msSDELayerInitItemInfo<br>
[Fri Jul 15 10:47:43 2011].122000 msSDELayerGetShape(): SDE
error. SE_stream_fetch_row(): Invalid parameter value passed to
function. (-66)<br>
[Fri Jul 15 10:47:43 2011].126000 msFreeMap(): freeing map at
01D3EFE8.<br>
[Fri Jul 15 10:47:43 2011].126000 msSDELayerCloseConnection():
Closing connection for layer Concelhos.<br>
[Fri Jul 15 10:47:43 2011].126000
msConnPoolRelease(Concelhos,ydinag2,port:5151,sde,sde,sde,01D6BCC0)<br>
[Fri Jul 15 10:47:43 2011].126000
msConnPoolClose(ydinag2,port:5151,sde,sde,sde,01D6BCC0)<br>
[Fri Jul 15 10:47:43 2011].156000 msSDELayerClose(): Closing
layer Concelhos.<br>
[Fri Jul 15 10:47:43 2011].156000
msConnPoolRelease(Concelhos,ydinag2,port:5151,sde,sde,sde,00000000)<br>
[Fri Jul 15 10:47:43 2011].156000 msConnPoolRelease(): Unable to
find handle for layer 'Concelhos'.<br>
[Fri Jul 15 10:47:43 2011].156000 msConnPoolRelease(): General
error message. Unable to find handle for layer 'Concelhos'.</small><br>
</blockquote>
<br>
<br>
Here part of my configuration:<br>
<blockquote type="cite">
<pre style="font-family:Consolas;font-size:13;color:black;background:white;"> 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'
</pre>
</blockquote>
<br>
I'm using Mapserver 5.6.3, I know it's not the latest but I didn't
updated yet. <br>
<br>
Any help would be useful and thx in advance.<br>
<br>
Mário Franco <br>
<br>
<div style="bottom: auto; left: 400px; right: auto; top: 69px;
display: none;" class="translator-theme-default" id="translator-floating-panel">
<div title="Click to translate" id="translator-floating-panel-button"></div>
</div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>mapserver-users mailing list</span><br><span><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a></span><br><span><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></span><br></div></blockquote></body></html>