<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
Dan,
<div class=""><br class="">
</div>
<div class="">That would work, but I was trying to color a 5 year old class one color, and the rest of them another, and do it all in one SQL call (single layer)
<div class=""><br class="">
</div>
<div class="">I got it to work in the DATA connection, but was trying to do the STYLE based query in the CLASS block.</div>
<div class=""><br class="">
</div>
<div class="">Seems like it would be doable, but I’m not having any luck yet. I’m guessing that the SYSDATE is not getting passed in correctly along with the INDATE value, at least based on what I see when I intentionally break the SQL to see the error.</div>
<div class=""><br class="">
</div>
<div class="">Also, there are only 1700 records to work with in there right now, quick return no matter what.</div>
<div class=""><br class="">
</div>
<div class="">bobb</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div class="">
<div>
<blockquote type="cite" class="">
<div class="">On Mar 29, 2016, at 11:10 AM, Dan Little <<a href="mailto:theduckylittle@gmail.com" class="">theduckylittle@gmail.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">You're probably better off with a view or querying against a stored procedure. There are a few advantages:
<div class="">1. With a view you can create multiple arbitrary views.</div>
<div class="">2. It keeps the syntax of the mapfile cleaner.</div>
<div class="">3. A view is easy to change to a materialized view in Oracle. That has a pile of performance benefits.</div>
<div class="">4. A stored procedure can be used to normalize the data better between Oracle and mapserver.</div>
<div class=""><br class="">
</div>
</div>
<div class="gmail_extra"><br class="">
<div class="gmail_quote">On Tue, Mar 29, 2016 at 10:53 AM, Basques, Bob (CI-StPaul)
<span dir="ltr" class=""><<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank" class="">bob.basques@ci.stpaul.mn.us</a>></span> wrote:<br class="">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word" class="">All Oracle Guru’s,
<div class=""><br class="">
</div>
<div class="">How do I handle an expression for doing a timed query in Oracle:</div>
<div class=""><br class="">
</div>
<div class="">
<div class=""><span style="white-space:pre-wrap" class=""></span><font face="Courier New" class="">CLASS</font></div>
<div class=""><font face="Courier New" class=""><span style="white-space:pre-wrap" class=""></span><font color="#ff2600" class=""><b class="">EXPRESSION ('[indate] > SYSDATE - 1825')</b></font></font></div>
<div class=""><font face="Courier New" class=""><span style="white-space:pre-wrap" class=""></span>COLOR 255 255 254</font></div>
<div class=""><font face="Courier New" class=""><span style="white-space:pre-wrap" class=""></span>OUTLINECOLOR 0 0 0</font></div>
<div class=""><font face="Courier New" class=""> <span style="white-space:pre-wrap" class="">
</span>SIZE 10</font></div>
<div class=""><font face="Courier New" class=""> <span style="white-space:pre-wrap" class="">
</span>SYMBOL 'circle'<span style="white-space:pre-wrap" class=""> </span></font></div>
<div class=""><font face="Courier New" class=""><span style="white-space:pre-wrap" class=""></span>NAME "PW Sidewalk Permits"</font></div>
<div class=""><font face="Courier New" class=""> <span style="white-space:pre-wrap" class="">
</span>END</font></div>
</div>
<div class=""><br class="">
</div>
<div class="">I want to get all the Permits up to 5 years old to plot. What should the EXPRESSION line look like above. I’ve tried all sort of different combinations of quoting, etc. I either get everything, or nothing.</div>
<div class=""><br class="">
</div>
<div class="">Thanks</div>
<div class=""><br class="">
</div>
<div class="">bobb</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
</div>
<br class="">
_______________________________________________<br class="">
mapserver-users mailing list<br class="">
<a href="mailto:mapserver-users@lists.osgeo.org" class="">mapserver-users@lists.osgeo.org</a><br class="">
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="noreferrer" target="_blank" class="">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br class="">
</blockquote>
</div>
<br class="">
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</body>
</html>