[mapserver-users] nQuery with SDE-Layer

[Oliver Wesp]

Dear List,

I'm facing some strange problems with nquery and SDE-Layers. Here is my
request:

http://myHost/cgi-bin/mapserv?map=/var/apache/htdocs/project/my.map&imge
xt=3360984.898934+5661892.942250+3416530.334032+5703843.458302&layer=myL
ayer&imgxy=477+53&savequery=true&mode=nquery&map_size=592+447

And here is what I get back from Mapserver:

CELL U1 U2 U3 
WXB---B 201799 9.15278 4.20013e+12 
WXB---A 136218 3.90833 3.5528e+11 
WXB---C 201756 7.95556 1.63827e+12 

And here - just to show the problem - is what I get back from an
SQL-Select-Statement:

     SHAPE CELL           U1       U2         U3
---------- ------- ---------- ---------- ----------
      5191 WXB---B         3    9,15278      71,28
      5146 WXB---A         2    3,90833      53,17
      5148 WXB---C         3    7,95556      61,96

For the items U1 and U3 the Mapserver-Results are wrong. Seems to me as
if the values for U1 are case-numbers. I have no clue where the values
for U3 came from. The same problem appears when I use the different
items in class-expressions. For U2 everything works fine, for U1 and U3
the whole thing is busted. All the Ux-Items are numbers.

And here is the setting:

Mapserver 3.6.1
ArcSDE 8.2
Solaris 8
Oracle 8i

any hints?

Oliver