[mapserver-users] EXPRESSION error with MapServer 6.2

[Jeff Lake]

shot in the dark ..
But I believe the error your getting in an actual MySQL error ..
your table name is a bit long ...

-Jeff Lake
MichiganWxSystem.com
AllisonHouse.com
TheWeatherCenter.net
GRLevelXStuff.com

On 11/29/2012 10:16, Astrid Emde wrote:
> Hello,
>
> I have a MapServer 6.2 question. I run MapServer 6.2 on Windows Server 2008.
>
> I noticed a strange behaviour with the EXPRESSION definition while I am
> migrating my mapfiles to MapServer 6.0
>
> This is my table:
> CREATE TABLE ax_bauwerkoderanlagefuerindustrieundgewerbe
> (
>    ogc_fid serial NOT NULL,
>    gml_id character(16), -- Identifikator, global eindeutig
>    ...
>    bauwerksfunktion integer,
>    wkb_geometry geometry
>    ...
> );
>
>
> DATA "wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry
> FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique
> ogc_fid USING SRID=25832"
>
> As bauwerksfunktion is an integer column my EXPRESSION definition was like
> this in MaServer < 6.0
>
> EXPRESSION ([bauwerksfunktion] = 1210)
> EXPRESSION ([bauwerksfunktion] = 1215 OR [bauwerksfunktion] = 1220 OR
> [bauwerksfunktion] = 1250 OR [bauwerksfunktion] = 1260)
>
> Now with MapServer 6.2 it does not work anymore:
> * instead of a map I get an Internal Server Error
>
> My Logfile says:
> [Thu Nov 29 15:03:31 2012].824000 msEvalExpression(): General error
> message. Invalid item index.
>
> I also checked http://mapserver.org/mapfile/expressions.html
>
> Does anyone has an idea?
>