<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 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 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";}
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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@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 lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">I’m working on a parcel viewer application, making a new service for GeoMoose. The idea is to input a town name, the scripts will then query the parcel shapefile’s dbf file (will probably switch to database soon, doesn’t matter for now),
this in turn populates a select list containing the parcel map-book-lot values for the selected town.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">So far, I’ve done that much and it works well. What I’d like to do next (and where I’m stuck) is to capture the selected parcel map-book-lot value, and send that to a followup service which actually queries the data layer. I experimented
with doing it as a form, and capturing the select value as a variable, without success.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Does anyone have suggestions? I know several of us are working with parcel viewing applications, and think it could be of interest. I’d be happy to submit this tool for all to use when it’s done.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Here is my code which creates the pick list (it is called as a service from the toolbar):<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><?<o:p></o:p></p>
<p class="MsoNormal">//Connect to the database<o:p></o:p></p>
<p class="MsoNormal">$objConnect = odbc_connect ('mapserver', '', '') or die('Could Not Connect to ODBC Database!');<o:p></o:p></p>
<p class="MsoNormal">$town=$_REQUEST['town'];<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">if($_REQUEST['town']){<o:p></o:p></p>
<p class="MsoNormal"> $command = "SELECT MAP_BK_LOT FROM parcels.dbf WHERE TOWN='".$_REQUEST['town']."'";<o:p></o:p></p>
<p class="MsoNormal"> $query=odbc_exec($objConnect,$command) or die ("Error executing query");<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">//Make a select list from the result set<o:p></o:p></p>
<p class="MsoNormal"> $results='<select name="parcellist" >';<o:p></o:p></p>
<p class="MsoNormal"> while($row=odbc_fetch_array($query)){<o:p></o:p></p>
<p class="MsoNormal"> $mapbklot = $row['MAP_BK_LOT'];<o:p></o:p></p>
<p class="MsoNormal"> $results.='<option value="'.$mapbklot.'">'.$mapbklot;<o:p></o:p></p>
<p class="MsoNormal"> }<o:p></o:p></p>
<p class="MsoNormal">$results.='</select>';<o:p></o:p></p>
<p class="MsoNormal">}<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">odbc_close($objConnect); //close database<o:p></o:p></p>
<p class="MsoNormal" style="text-align:justify"><o:p> </o:p></p>
<p class="MsoNormal" style="text-align:justify">//print the select list to the window<o:p></o:p></p>
<p class="MsoNormal" style="text-align:justify">header('Content-type: text/xml');<o:p></o:p></p>
<p class="MsoNormal" style="text-align:justify">print "<results>";<o:p></o:p></p>
<p class="MsoNormal" style="text-align:justify">print "<script><![CDATA[";<o:p></o:p></p>
<p class="MsoNormal" style="text-align:justify">print "]]></script>";<o:p></o:p></p>
<p class="MsoNormal" style="text-align:justify">print "<html><![CDATA[";<o:p></o:p></p>
<p class="MsoNormal" style="text-align:justify">print $output;<o:p></o:p></p>
<p class="MsoNormal" style="text-align:justify">print $results; <o:p></o:p></p>
<p class="MsoNormal">print '<div style="display: [SHOW_FOLLOWUP]"/>';<o:p></o:p></p>
<p class="MsoNormal">print "<br/><br/>";<o:p></o:p></p>
<p class="MsoNormal">print "</div>";<o:p></o:p></p>
<p class="MsoNormal">print "]]></html>";<o:p></o:p></p>
<p class="MsoNormal">print "</results>";<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">?><o:p></o:p></p>
</div>
</body>
</html>