<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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: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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
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.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
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";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1465197825;
mso-list-type:hybrid;
mso-list-template-ids:1766126398 777934968 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-text:%1;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.25in;
text-indent:-1.0in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</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 lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>I had a client request something that sounds really cool,
but I don’t know how to do it (or if it is even possible in mapserver).<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>First, my setup:<o:p></o:p></p>
<p class=MsoNormal>I am running MS4W 2.6 on windows xp against postgis 8.2
database. I have table A that has anywhere from 4 to 35 rows. And
table B which could have several hundred rows each relating back to one of the
rows from table A.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>For Example:<o:p></o:p></p>
<p class=MsoNormal>TableA<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>ID Name<o:p></o:p></p>
<p class=MsoListParagraph style='margin-left:1.25in;text-indent:-1.0in;
mso-list:l0 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>1<span
style='font:7.0pt "Times New Roman"'>
</span></span><![endif]>t<o:p></o:p></p>
<p class=MsoListParagraph style='margin-left:1.25in;text-indent:-1.0in;
mso-list:l0 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>2<span
style='font:7.0pt "Times New Roman"'>
</span></span><![endif]>t2<o:p></o:p></p>
<p class=MsoListParagraph style='margin-left:1.25in;text-indent:-1.0in;
mso-list:l0 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>3<span
style='font:7.0pt "Times New Roman"'>
</span></span><![endif]>t3<o:p></o:p></p>
<p class=MsoListParagraph style='margin-left:1.25in;text-indent:-1.0in;
mso-list:l0 level1 lfo1'><![if !supportLists]><span style='mso-list:Ignore'>4<span
style='font:7.0pt "Times New Roman"'>
</span></span><![endif]>t4<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>TableB<o:p></o:p></p>
<p class=MsoNormal>ID ta_id Value<o:p></o:p></p>
<p class=MsoNormal>1 1 something<o:p></o:p></p>
<p class=MsoNormal>2 1 something
else<o:p></o:p></p>
<p class=MsoNormal>3 1 test<o:p></o:p></p>
<p class=MsoNormal>4 2 foo<o:p></o:p></p>
<p class=MsoNormal>5 2 bar<o:p></o:p></p>
<p class=MsoNormal>6 3 done<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Now my problem:<o:p></o:p></p>
<p class=MsoNormal>The client would like to see all the rows rendered from
tableA as different colors. These colors can be random, it doesn’t
matter. On top of this, they want to see all the associated rows in
tableB as the same color as their parent from tableA.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Can I add a column to tableA and use that as a value in the
mapfile for the style? And if so, how?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I would greatly appreciate any help that anyone can provide.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks in advance,<o:p></o:p></p>
<p class=MsoNormal>Lee<o:p></o:p></p>
</div>
</body>
</html>