AW: [mapserver-users] nQuery with SDE-Layer

[Oliver Wesp]

O.k. we fixed the problem. Seems like there is problem with getting
integer- or float-values out our SDE-Database. Double-Values are working
fine. This has something to do with motorola-byteorder and passing
values in mapsde.c . We fixed the problem right now and submitted our
changes to Steve Lime. If anybody is facing this problem, feel free to
contact me.

greetings
Oliver

> -----Ursprüngliche Nachricht-----
> Von: owner-mapserver-users at lists.gis.umn.edu 
> [mailto:owner-mapserver-users at lists.gis.umn.edu] Im Auftrag 
> von Oliver Wesp
> Gesendet: Freitag, 9. August 2002 16:40
> An: mapserver-users at lists.gis.umn.edu
> Betreff: [mapserver-users] nQuery with SDE-Layer
> 
> 
> 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