<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=WordSection1>
<p class=MsoNormal><span style='color:#1F497D'>Anyone have anymore ideas about
this….<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I have a string field with
values<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>And the code below. The expression
does not seem to be running…if I only use LASTTWOWEEKS it still draws all the
points….and I know there are values in there from 2008<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'>
mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Jay
Kapalczynski<br>
<b>Sent:</b> Tuesday, September 21, 2010 9:51 AM<br>
<b>To:</b> 'Bob Basques'; mapserver-users@lists.osgeo.org<br>
<b>Subject:</b> RE: [mapserver-users] Expressions<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#0F243E'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='color:#0F243E'>My
major question is can I do this with a String/text field? Its the only
way I can see keeping things in a </span><span style='font-size:9.5pt;
font-family:Consolas;color:#0F243E'>%2Y%2M%2D format ex. 092110
(Sept 21<sup>st</sup> 2010), otherwise the 0 will get removed in a numeric
field<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:9.5pt;
font-family:Consolas;color:#0F243E'>Can I use the format Year, Month,
Day? Or do I have to use Month, Day, Year?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>In this example I eliminated two
expressions and focused on one Expression to see if it is working.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><u><span style='color:#1F497D'>I kept this<o:p></o:p></span></u></b></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'> <</span><span style='font-size:8.0pt;
font-family:Consolas;color:#A31515'>map-source</span><span style='font-size:
8.0pt;font-family:Consolas;color:blue'> </span><span style='font-size:8.0pt;
font-family:Consolas;color:red'>name</span><span style='font-size:8.0pt;
font-family:Consolas;color:blue'>=</span><span style='font-size:8.0pt;
font-family:Consolas;color:windowtext'>"</span><span style='font-size:
8.0pt;font-family:Consolas;color:blue'>Burglaries</span><span style='font-size:
8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>type</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>mapserver</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>></span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'> <</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>file</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>></span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>./maple_grove_datasets/police/Burglaries.map</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'></</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>file</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>></span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'> <</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>param</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>type</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>today</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>-7</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>name</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>LASTWEEK</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>format</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> /></span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'> <</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>param</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>type</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>today</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>-14</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>name</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>LASTTWOWEEKS</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>format</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> /></span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'> <</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>param</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>type</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>today</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>-30</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>name</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>LASTTHIRTY</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>format</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> /></span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'> <</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>param</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>type</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>today</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>-90</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>name</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>LASTNINTY</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>format</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> /></span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'> <</span><span
style='font-size:8.0pt;font-family:Consolas;color:#A31515'>layer</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'> </span><span
style='font-size:8.0pt;font-family:Consolas;color:red'>name</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>Burglaries</span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'>"</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>/></span><span
style='font-size:8.0pt;font-family:Consolas;color:windowtext'><o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:blue'> </</span><span style='font-size:
8.0pt;font-family:Consolas;color:#A31515'>map-source</span><span
style='font-size:8.0pt;font-family:Consolas;color:blue'>><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><u><span style='color:#1F497D'>In my map file I used </span></u></b><b><u><span
style='color:red'>ONLY</span></u></b><b><u><span style='color:#1F497D'> this<o:p></o:p></span></u></b></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>CLASS<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>
NAME 'Last Weeks'<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>
EXPRESSION ('[dateValues]' > '%LASTTWOWEEKS%')<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>
STYLE<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>
COLOR 0 100 50 <o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>
SYMBOL "bike" <o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>
SIZE 12<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>
END <o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:8.0pt;
font-family:Consolas;color:#632423'>END<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Now in my data I have these
values (below), although every symbol was displayed in the map<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>NOTE THIS IS A TEXT FIELD<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>081204, 081225,090118<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>These values (above) for the Year,
Month, Day format specified in the map source are clearly less than the “last
two weeks”, Where as they are older than the last 14 days….so none of them
should show up, but they do<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Any thoughts<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'>
mapserver-users-bounces@lists.osgeo.org [mailto:mapserver-users-bounces@lists.osgeo.org]
<b>On Behalf Of </b>Bob Basques<br>
<b>Sent:</b> Friday, September 17, 2010 9:25 PM<br>
<b>To:</b> mapserver-users@lists.osgeo.org<br>
<b>Subject:</b> Re: [mapserver-users] Expressions<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>A first stab at seeing more than one class, might be to try
and switch them around order wise, one filter may be overwriting the
other for example.<br>
<br>
bobb<br>
<br>
<br>
<br>
<br>
On 9/17/2010 8:20 AM, Jay Kapalczynski wrote: <o:p></o:p></p>
<p class=MsoNormal>I am using GeoMoose but feel this is more a question for Map
Server.<o:p></o:p></p>
<p class=MsoNormal>I am trying to sort my points by dates using the code
below….I think that I can do this but not sure<o:p></o:p></p>
<p class=MsoNormal>Is this a viable format “2Y%2M%2D” ? <o:p></o:p></p>
<p class=MsoListParagraph style='text-indent:-.25in'>As for the field in the
shapefile…If I use an integer it removes the 0 from the 092110, (sept 21<sup>st</sup>
2010)<o:p></o:p></p>
<p class=MsoListParagraph style='text-indent:-.25in'>If I use a date then there
are “/” … 9/21/10<o:p></o:p></p>
<p class=MsoListParagraph style='text-indent:-.25in'>The only way I can see
this happening is using a text field with retains the 0 in 092110<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>When I use the textfield “dateValues” as seen below I can
get the stars to draw but only the LASTWEEK…for some reason the LASTTWOWEEKS
does not show and I know that I have a few records with dates in the last
14 days…<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>Thoughts?<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>THANKS….all your help is very appreciated….<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>Main .xml file<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'> <</span><span style='font-size:9.5pt;font-family:Consolas;
color:#A31515'>map-source</span><span style='font-size:9.5pt;font-family:Consolas;
color:blue'> </span><span style='font-size:9.5pt;font-family:Consolas;
color:red'>name</span><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>=</span><span style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>Burglaries</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>type</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>mapserver</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>></span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'> <</span><span style='font-size:9.5pt;
font-family:Consolas;color:#A31515'>file</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'>></span><span style='font-size:9.5pt;
font-family:Consolas'>./maple_grove_datasets/police/Burglaries.map</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'></</span><span
style='font-size:9.5pt;font-family:Consolas;color:#A31515'>file</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>></span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'> <</span><span style='font-size:9.5pt;
font-family:Consolas;color:#A31515'>param</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'> </span><span style='font-size:9.5pt;
font-family:Consolas;color:red'>type</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'>=</span><span style='font-size:9.5pt;
font-family:Consolas'>"</span><span style='font-size:9.5pt;font-family:
Consolas;color:blue'>today</span><span style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>-7</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>name</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>LASTWEEK</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>format</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> /></span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'> <</span><span style='font-size:9.5pt;
font-family:Consolas;color:#A31515'>param</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'> </span><span style='font-size:9.5pt;
font-family:Consolas;color:red'>type</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'>=</span><span style='font-size:9.5pt;
font-family:Consolas'>"</span><span style='font-size:9.5pt;font-family:
Consolas;color:blue'>today</span><span style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>-14</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>name</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>LASTTWOWEEKS</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>format</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> /></span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'> <</span><span style='font-size:9.5pt;
font-family:Consolas;color:#A31515'>param</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'> </span><span style='font-size:9.5pt;
font-family:Consolas;color:red'>type</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'>=</span><span style='font-size:9.5pt;
font-family:Consolas'>"</span><span style='font-size:9.5pt;font-family:
Consolas;color:blue'>today</span><span style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>-30</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>name</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>LASTTHIRTY</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>format</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> /></span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'> <</span><span style='font-size:9.5pt;
font-family:Consolas;color:#A31515'>param</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'> </span><span style='font-size:9.5pt;
font-family:Consolas;color:red'>type</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'>=</span><span style='font-size:9.5pt;
font-family:Consolas'>"</span><span style='font-size:9.5pt;font-family:
Consolas;color:blue'>today</span><span style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>offset</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>-90</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>name</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>LASTNINTY</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> </span><span
style='font-size:9.5pt;font-family:Consolas;color:red'>format</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>=</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'>%2Y%2M%2D</span><span
style='font-size:9.5pt;font-family:Consolas'>"</span><span
style='font-size:9.5pt;font-family:Consolas;color:blue'> /></span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'> <</span><span style='font-size:9.5pt;
font-family:Consolas;color:#A31515'>layer</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'> </span><span style='font-size:9.5pt;
font-family:Consolas;color:red'>name</span><span style='font-size:9.5pt;
font-family:Consolas;color:blue'>=</span><span style='font-size:9.5pt;
font-family:Consolas'>"</span><span style='font-size:9.5pt;font-family:
Consolas;color:blue'>Burglaries</span><span style='font-size:9.5pt;font-family:
Consolas'>"</span><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>/></span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas;
color:blue'> </</span><span style='font-size:9.5pt;font-family:Consolas;
color:#A31515'>map-source</span><span style='font-size:9.5pt;font-family:Consolas;
color:blue'>></span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>.map file<o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal>CL<span style='font-size:9.5pt;font-family:Consolas'>ASS</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
NAME 'Last Weeks'</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
EXPRESSION ('[dateValues]' > '%LASTWEEK%')</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
STYLE</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
COLOR 0 0 0 </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
SYMBOL "star" </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
SIZE 12</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
END </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>END</span><o:p></o:p></p>
<p class=MsoNormal>CL<span style='font-size:9.5pt;font-family:Consolas'>ASS</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
NAME 'Last Two Weeks'</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
EXPRESSION ('[dateValues]' > '%LASTTWOWEEKS%')</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
STYLE</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
COLOR 0 100 50 </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
SYMBOL "star" </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
SIZE 12</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>
END </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:9.5pt;font-family:Consolas'>END</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>mapserver-users mailing list<o:p></o:p></pre><pre><a
href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><o:p></o:p></pre><pre><a
href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><o:p></o:p></pre></div>
</body>
</html>