Hi List,<br><br>Thanks, that works. <br>But <b>this doesn't</b> and I need something like in the Class definitions below. What should I do in this condition?<br>Is it about this; <a href="http://trac.osgeo.org/mapserver/ticket/2817">http://trac.osgeo.org/mapserver/ticket/2817</a><br>
Using ms4w 5.4.0-rc2.<span class="ul-threaded" style="margin: 0.5em 0pt 0pt -20px;"><span class="text-cell"></span></span><br><br> CLASSITEM "name"<br><br> CLASS<br> EXPRESSION ([id] = 5)<br> MAXSCALEDENOM 4000<br>
MINSCALEDENOM 1000<br> NAME "1"<br> STYLE<br> COLOR [color2]<br> END<br> STYLE<br> OUTLINECOLOR 20 20 20<br> WIDTH 3<br>
END<br> END<br> <br>CLASS<br> EXPRESSION /xyz/<br> NAME "2"<br> STYLE<br> OUTLINECOLOR 0 0 0<br> WIDTH 20<br> END<br>
END<br><br><b>OR</b><br><br>#CLASSITEM 'name' # Without CLASSITEM definition<br>CLASS<br>
EXPRESSION ('[name]' eq /xyz/ AND [id] = 5)<br>
NAME "GID_S"<br>
STYLE<br>
OUTLINECOLOR 0 0 0<br>
WIDTH 20<br>
END<br>
END<br><br><div class="gmail_quote">On Tue, Oct 5, 2010 at 8:08 PM, Lime, Steve D (DNR) <span dir="ltr"><<a href="mailto:Steve.Lime@state.mn.us">Steve.Lime@state.mn.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
You can use regular expressions instead. E.g.<br>
<br>
Classitem 'name'<br>
Class<br>
Expression /xyz/<br>
End<br>
<br>
Steve<br>
<br>
________________________________________<br>
From: <a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a> [<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a>] On Behalf Of Ibrahim Saricicek [<a href="mailto:ibrahimsaricicek@gmail.com">ibrahimsaricicek@gmail.com</a>]<br>
Sent: Tuesday, October 05, 2010 8:08 AM<br>
To: <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
Subject: [mapserver-users] Expressions<br>
<br>
Hi List;<br>
<br>
instead of an sql ,in the connection string including 'LIKE';<br>
(select id, name,the_geom from public.mytable where name like '%xyz%')<br>
I would like to use an expression.<br>
But documents say "The following logical operators are supported:<br>
=,>,<,<=,>=,=,or,and,lt,gt,ge,le,eq,ne"<br>
<br>
How can I use something like this?<br>
CLASS<br>
EXPRESSION ([name] like '%xyz%')<br>
<br>
Thanks in Advance...<br>
<font color="#888888">--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/Expressions-tp5603053p5603053.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/Expressions-tp5603053p5603053.html</a><br>
Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
<br>
<br>
</font></blockquote></div><br>