Expression not working on mapserver

[Lego han (aka Doig)]

Thanks.  I actually got the quote issues worked out.  It looks like
this: EXPRESSION ('[roadtype]' = 'freeway')
now.  Quoting column names just doesn't come naturally to me.


On 8/1/05, Steve Lime <steve.lime at dnr.state.mn.us> wrote:
> There are 2 problems:
> 
> 1) EXPRESSION "([roadtype] = 'freeway')" should be
>     EXPRESSION ([roadtype] = 'freeway')
> 
> No qoutes around the logical expression otherwise MapServer treats the whole thing as one big string.
> 
> 2) EXPRESSION ([roadtype] = 'freeway') should be
>     EXPRESSION ('[roadtype]' = 'freeway')
> 
> MapServer doesn't know anything about item types or anything so you must be overly explicit when preparing expressions. Same applies to the rest of your mapfile.
> 
> Steve
> 
> >>> "Lego han (aka Doig)" <legoist at GMAIL.COM> 08/01/05 10:10 PM >>>
>   Below I have a snippet of a map file...  I get a blank image every
> time I use the expression.  If I comment it out everything appears.
> When I run the query, I get data....  What's the problem here?  I've
> tried Quotes, no Quotes, all sorts of iterations.
> 
> Help...
> 
> 
>   DATA "the_geom from (SELECT the_geom,CASE WHEN cfcc IN
>  ('A11','A12','A13','A14','A15','A16')
>   THEN 'freeway' ELSE 'road' END as roadtype,cfcc,
>   fename,oid FROM roads) as foo USING unique oid"
>  TYPE LINE
>          STATUS ON
>          CLASS
>          EXPRESSION "([roadtype] = 'freeway')"
>           STYLE
>                  COLOR 55 50 0
>                  OUTLINECOLOR 200 200 200
>                  SYMBOL 0
>                  MINSIZE 3
>                  SIZE 5
>          END
>          END
>           CLASS
>            EXPRESSION ([fename] = 'Monroe')
>            STYLE
>            COLOR 255 0 0
>            OUTLINECOLOR 200 200 200
>            SYMBOL 0
>            SIZE 3
>            END
>          END
> 
>