[mapserver-users] Expressions & SDE Layer -- More Info

[Robert Aldridge]

I tried the same thing on a hydrology layer that has a
"hydtype" item that is defined as a LONG INTEGER and
it worked perfectly.



--- Robert Aldridge <bamarob55 at yahoo.com> wrote:
> Date: Thu, 14 Jun 2001 08:13:24 -0700 (PDT)
> From: Robert Aldridge <bamarob55 at yahoo.com>
> Subject: Expressions & SDE Layer
> To: MapServer_Users
> <mapserver-users at lists.gis.umn.edu>
> 
> Hello all,
> 
> I have a layer in my map file defined as follows:
> 
> LAYER
>   NAME "Roads"
>   TYPE LINE
>   STATUS DEFAULT
>   CONNECTIONTYPE sde
>   CONNECTION "comtrac,esri_sde,ArcInfo,sde,passwd"
>   DATA "sde.roads,shape"
>   CLASSITEM "roadtype"
>   CLASS
>     EXPRESSION /1/
>     SYMBOL 1
>     SIZE 1
>     COLOR 255 0 0
>   END
>   CLASS
>     EXPRESSION /2/
>     SYMBOL 1
>     SIZE 1
>     COLOR 0 0 0
>   END
> END
> 
> Drawing the layer works fine without the
> expressions. 
> The "roadtype" item is defined as a SMALLINT in my
> database.  I get the following error with the above
> layer definition:
> 
> sdeGetRecord(): SDE error. SE_stream_get_integer():
> Wrong column type. (-114)
> 
> Changing the CLASSITEM to "cfcc" (which is a string
> item) and using "A41" and "A31" in the two
> expressions
> works fine.
> 
> I'm wondering if this might be a bug because it is
> errorring out on SE_stream_get_integer when the item
> type is smallint.
> 
> Any ideas?
> 
> Thanks,
> 
> Robert Aldridge
> 
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail -
> only $35 
> a year!  http://personal.mail.yahoo.com/
> 


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/