[mapserver-users] sde query and EXPRESSION error in sde

[Steffens, Ludger]

Hi,

We have to draw and query a map which is based on an arcsde database.

Case 1:
I want to query an object, which is of type point. The objects are in an

arcsde geodata-server, which I connect with the following statement:

CONNECTION "xxx.dcnv.xxx.de,port:5151,sde,xxx,xxx"
CONNECTIONTYPE SDE
DATA "xxx.xTS,SHAPE,SDE.DEFAULT"

As a result I get the following error: 

Content-type: text/html msSDELayerGetShape(): SDE error. 
SE_stream_fetch_row(): Invalid parameter value passed to function. (-66)

There is a great number of points which I do have to query, and there
are also 
cases (points) , which might have a NULL-field within the list of
attributs 
for a specific point. 

If I query objects which are polygon type everything is fine, i.e. I
don't get 
any errors.

Case 2:
I want to draw another layer based on the same connection statement,
i.e. also 
point object  in an arcsde database. The attribut are of type 
SE_INT32. When I issue an EXPRESSION statement , i.e. 
EXPRESSION  ([WINKEL] > 0 ),
mapserver complains this with the error message

msyyparse(): Expression parser error. syntax error
msEvalExpression: Expression parser error. Failed to parse expression:
<null> 
> 0

What do I do wrong? 
Or, is there an error in the sde database?
Mapserver was build including arcsde library sdeexe92 and use the
configure 
statement " --with-sde-version=92"

I really would appreciate any ideas in solving these errors.

Ludger


T-Mobile Deutschland GmbH
Aufsichtsrat: Hamid Akhavan (Vorsitzender)
Geschaftsfuhrung: Philipp Humm (Sprecher), Thomas Berlemann, Jiri Dvorjancansky, Dr. Peter Korner, Gunther Ottendorfer, Dr. Raphael Kubler, Dr. Steffen Roehn
Handelsregister: Amtsgericht Bonn, HRB 59 19
Sitz der Gesellschaft: Bonn
WEEE-Reg.-Nr.: DE60800328