<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=utf-8">
<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:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 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";
mso-believe-normal-left:yes;}
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;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
p
{mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
span.plaintextchar0
{mso-style-name:plaintextchar;
font-family:Consolas;}
span.EmailStyle21
{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 mso 9]>
<style>
p.MsoNormal
{margin-left:3.0pt;}
</style>
<![endif]><!--[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 lang=EN-US link=blue vlink=purple style='margin-left:3.0pt;margin-top:
3.0pt;margin-right:3.0pt;margin-bottom:.75pt'>
<div class=WordSection1>
<p class=MsoNormal><span style='color:#1F497D'>Thanks bob…..I did see that but
made sure the expression followed suit<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> <param
type="today" offset="-14" name="</span><b><span
style='font-size:9.0pt;color:#0070C0'>LASTTWOWEEKS</span></b><span
style='font-size:9.0pt;color:#632423'>" format="%4Y%2M%2D" />
<o:p></o:p></span></p>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> <param
type="today" offset="-7" name="</span><b><span
style='font-size:9.0pt;color:#0070C0'>LASTWEEK</span></b><span
style='font-size:9.0pt;color:#632423'>" format="%4Y%2M%2D" />
<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='font-size:9.0pt;color:#632423'> EXPRESSION
('[IncidentDa]' > '%</span><b><span style='font-size:9.0pt;color:#0070C0'>LASTTWOWEEKS</span></b><span
style='font-size:9.0pt;color:#632423'>%' && '[IncidentDa]' < '%</span><b><span
style='font-size:9.0pt;color:#0070C0'>LASTWEEK</span></b><span
style='font-size:9.0pt;color:#632423'>%')<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;color:#632423'><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"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Bob Basques
[mailto:Bob.Basques@ci.stpaul.mn.us] <br>
<b>Sent:</b> Wednesday, September 29, 2010 10:52 AM<br>
<b>To:</b> Jay Kapalczynski; mapserver-users@lists.osgeo.org; 'Stephen
Woodbridge'<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><span style='font-family:"Comic Sans MS"'>Don't know if it matters, but you
have a LASTWEEK and LASTWEEKS in there. Should they both be one or the
other?</span> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p><span style='font-family:"Comic Sans MS"'>bobb</span> <o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p><br>
<br>
>>> Jay Kapalczynski <jkapalczynski@ci.maple-grove.mn.us> wrote:<o:p></o:p></p>
<div style='border:none;border-left:solid #050505 1.0pt;padding:0in 0in 0in 5.0pt;
margin-left:11.25pt'>
<div>
<p class=MsoPlainText style='background:#F3F3F3'>I thank you for your
response....greatly appreciated as I cannot figure this out.... <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>I know that I have 4 features
in the dataset that have a value of 20100916 that’s 13 days
ago....so with the expression below those 4 or 5 features should show up....but
nothing shows up <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>IncidentDa is the field (long
integer) <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>Param type is specifying
YYYYMMDD my data has values of 20100916 (13 days) <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>I have no idea what could be
wrong…Thank you all for your help…. <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:black'>.XML
file <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> <map-source
name="Burglaries" type="mapserver"> <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> <file>./maple_grove_datasets/police/Burglaries.map</file>
<o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> <param
type="today" offset="-90" name="LASTNINTY"
format="%4Y%2M%2D" /> <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> <param
type="today" offset="-30" name="LASTTHIRTY"
format="%4Y%2M%2D" /> <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> <param
type="today" offset="-14" name="LASTTWOWEEKS"
format="%4Y%2M%2D" /> <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> <param
type="today" offset="-7" name="LASTWEEK"
format="%4Y%2M%2D" /> <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> <param
type="today" offset="0" name="TODAY"
format="%4Y%2M%2D" /> <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> <layer
name="Burglaries"/> <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> </map-source>
<o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'>
<o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:black'>.MAP
file <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'>CLASS
<o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> NAME
'Last Weeks' <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> EXPRESSION
('[IncidentDa]' > '%LASTTWOWEEKS%' && '[IncidentDa]' <
'%LASTWEEK%') <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> STYLE
<o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> COLOR
0 100 50 <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> SYMBOL
"bike" <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> SIZE
12 <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'> END
<o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;color:#632423'>END <o:p></o:p></span></p>
</div>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>=======================================
<o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>BUT if I simply place this in
there I get all the points…so something is weird here because most of the dates
are older than 7 days. <o:p></o:p></p>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'>CLASS <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'> NAME 'Last Weeks' <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'> EXPRESSION
('[IncidentDa]' > '%LASTWEEK%’) <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'> STYLE <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'> COLOR
0 0 0 <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'> SYMBOL
"tent" <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'> SIZE
12 <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'>END <o:p></o:p></span></p>
</div>
<p class=MsoNormal style='background:#F3F3F3'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div>
<p style='background:#F3F3F3'><span style='font-size:9.0pt;font-family:Consolas;
color:#632423'>#END <o:p></o:p></span></p>
</div>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>-----Original Message-----<br>
From: mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] On Behalf Of Stephen
Woodbridge<br>
Sent: Wednesday, September 29, 2010 8:19 AM<br>
To: mapserver-users@lists.osgeo.org<br>
Subject: Re: [mapserver-users] Expressions <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>In EXPRESSIONS you can
evaluate any of the following: <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>1. Regular expressions
treating the value as a string <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>2. numeric expressions using
booleans like ==,<,>,<=,>= <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>3. string expressions like ==,
!=, and I think strlen() <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>So if you converted you dates
into a format like YYYYMMDD then it would <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>be easy to use a numeric
expression like: <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>EXPRESSION ('[dateValues]'
> '%STARTDATE%' && '[dateValues]' < '%ENDDATE%') <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>or <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>EXPRESSION ('[dateValues]'
> '%STARTDATE%') <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>where STARTDATE is the YYYYMMDD
value of two weeks ago and ENDDATE would <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>be in the same format and
allow you to extract record betwee any two <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>start and end dates. <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>Or you might be able to figure
out a complex regular expression the <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>represents the last two weeks
like: <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>EXPRESSION ('[dateValues]'
=~ '/%LASTTWOWEEKS%/') <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>I'm not sure what you would
need for the regular expression. <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>-Steve W <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>On 9/28/2010 4:23 PM, Jay
Kapalczynski wrote: <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> Anyone have anymore ideas
about this…. <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> I have a string field
with values <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> And the code below. The
expression does not seem to be running…if I only <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> use LASTTWOWEEKS it still
draws all the points….and I know there are <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> values in there from 2008
<o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> Thanks <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> *From:*
mapserver-users-bounces@lists.osgeo.org <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> [mailto:mapserver-users-bounces@lists.osgeo.org]
*On Behalf Of *Jay <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> Kapalczynski <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> *Sent:* Tuesday,
September 21, 2010 9:51 AM <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> *To:* 'Bob Basques';
mapserver-users@lists.osgeo.org <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> *Subject:* RE:
[mapserver-users] Expressions <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> My major question is can
I do this with a String/text field? Its the <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> only way I can see
keeping things in a %2Y%2M%2D format ex. 092110 (Sept <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> 21^st 2010), otherwise
the 0 will get removed in a numeric field <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> Can I use the format
Year, Month, Day? Or do I have to use Month, Day, Year? <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> In this example I
eliminated two expressions and focused on one <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> Expression to see if it
is working. <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> *_I kept this_* <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <map-source
name="Burglaries" type="mapserver"> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <file>./maple_grove_datasets/police/Burglaries.map</file>
<o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <param
type="today" offset="-7" name="LASTWEEK"
format="%2Y%2M%2D" /> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <param
type="today" offset="-14" name="LASTTWOWEEKS"
format="%2Y%2M%2D" /> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <param
type="today" offset="-30" name="LASTTHIRTY"
format="%2Y%2M%2D" /> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <param
type="today" offset="-90" name="LASTNINTY"
format="%2Y%2M%2D" /> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <layer
name="Burglaries"/> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> </map-source> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> *_In my map file I used
_**_ONLY_**_ this_* <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> CLASS <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> NAME 'Last Weeks' <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> EXPRESSION
('[dateValues]' > '%LASTTWOWEEKS%') <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> STYLE <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> COLOR 0 100 50 <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> SYMBOL "bike" <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> SIZE 12 <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> END <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> END <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> Now in my data I have
these values (below), although every symbol was <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> displayed in the map <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> NOTE THIS IS A TEXT FIELD
<o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> 081204, 081225,090118 <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> These values (above) for
the Year, Month, Day format specified in the <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> map source are clearly
less than the “last two weeks”, Where as they are <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> older than the last 14
days….so none of them should show up, but they do <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> Any thoughts <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> *From:*
mapserver-users-bounces@lists.osgeo.org <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>>
[mailto:mapserver-users-bounces@lists.osgeo.org] *On Behalf Of *Bob Basques <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> *Sent:* Friday, September
17, 2010 9:25 PM <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> *To:* mapserver-users@lists.osgeo.org
<o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> *Subject:* Re:
[mapserver-users] Expressions <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> A first stab at seeing
more than one class, might be to try and switch <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> them around order wise,
one filter may be overwriting the other for example. <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> bobb <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> On 9/17/2010 8:20 AM, Jay
Kapalczynski wrote: <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> I am using GeoMoose but
feel this is more a question for Map Server. <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> I am trying to sort my
points by dates using the code below….I think <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> that I can do this but
not sure <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> Is this a viable
format “2Y%2M%2D” ? <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> As for the field in the
shapefile…If I use an integer it removes the 0 <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> from the 092110, (sept
21^st 2010) <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> If I use a date then
there are “/” … 9/21/10 <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> The only way I can see
this happening is using a text field with retains <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> the 0 in 092110 <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> When I use the
textfield “dateValues” as seen below I can get the stars <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> to draw but only the
LASTWEEK…for some reason the LASTTWOWEEKS does not <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> show and I know that I
have a few records with dates in the last 14 days… <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> Thoughts? <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> THANKS….all your help is
very appreciated…. <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> Main .xml file <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <map-source
name="Burglaries" type="mapserver"> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>>
<file>./maple_grove_datasets/police/Burglaries.map</file> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <param
type="today" offset="-7" name="LASTWEEK"
format="%2Y%2M%2D" /> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <param
type="today" offset="-14" name="LASTTWOWEEKS"
format="%2Y%2M%2D" /> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <param
type="today" offset="-30" name="LASTTHIRTY"
format="%2Y%2M%2D" /> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <param
type="today" offset="-90" name="LASTNINTY"
format="%2Y%2M%2D" /> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <layer
name="Burglaries"/> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> </map-source> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> .map file <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> CLASS <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> NAME 'Last Weeks' <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> EXPRESSION
('[dateValues]' > '%LASTWEEK%') <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> STYLE <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> COLOR 0 0 0 <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> SYMBOL "star" <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> SIZE 12 <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> END <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> END <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> CLASS <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> NAME 'Last Two Weeks' <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> EXPRESSION
('[dateValues]' > '%LASTTWOWEEKS%') <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> STYLE <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> COLOR 0 100 50 <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> SYMBOL "star" <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> SIZE 12 <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> END <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> END <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>>
_______________________________________________ <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> mapserver-users mailing
list <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>>
mapserver-users@lists.osgeo.org <mailto:mapserver-users@lists.osgeo.org>
<o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>>
http://lists.osgeo.org/mailman/listinfo/mapserver-users <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>>
_______________________________________________ <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>> mapserver-users mailing
list <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>>
mapserver-users@lists.osgeo.org <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>>
http://lists.osgeo.org/mailman/listinfo/mapserver-users <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'> <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>_______________________________________________
<o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>mapserver-users mailing list <o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>mapserver-users@lists.osgeo.org
<o:p></o:p></p>
<p class=MsoPlainText style='background:#F3F3F3'>http://lists.osgeo.org/mailman/listinfo/mapserver-users
<o:p></o:p></p>
</div>
</div>
</div>
</body>
</html>