Parse a String?

Moonpie10 · Mar 3, 2005

Hi,
I have some javascript that fills a select box based on the selection in another select box. The fill is coming from a database of which I have put the data into a string into my javascript. I want to enhance this script to read the string and only select certain items from the string based on the selected index in the first box, right now I am getting everything. For example is Canada is chosen then the data in the database Alberta and Manitoba should be displayed but right now I see Alberta, Manitoba and Colorado. I am not real familiar with javascript, can someone look at my code and make a suggestion? Thanks!

<%
String option = "";
ResultSet rs = statement.executeQuery("Select * "
+ "from partDB.profile_geo "
+ "where partid= '" + pid + "' ");
Vector dbList = new Vector();
while (rs.next()) {
option = "<option value=\"" + rs.getString("region").trim() + "\">" + rs.getString("cst").trim();
dbList.add(option);
}

String dbString = " ";

for (int i = 0; i < dbList.size(); i++) {
String dString = dbList.get(i).toString();
dbString = dbString + dString.trim() ;
}

%>

<script language="javascript">

Africa='<%=terrString%>';
AsiaPacific='<%=terrString%>';
Canada='<%=terrString%>';
Europe='<%=terrString%>';
LatinAmerica='<%=terrString%>';
MiddleEast='<%=terrString%>';
UnitedStates='<%=stateString%>';
Region='<%=dbString%>';

function PopulateSelect2(obj1,id2){

if (obj1.selectedIndex<0){ return; }

obj2=document.getElementById(id2)
obj2.options.length=0;

obj3=document.getElementById("selectedOptions");
obj3.options.length=0;

ThisString=obj1.options[obj1.selectedIndex].value;
ThisString=eval(ThisString);

for (i=0;i<ThisString.split('<').length-1;i++){
obj2.options=new Option(ThisString.split('<')[i+1].split('>')[1],ThisString.split('<')[i+1].split('>')[1],true,true);
}

obj2.selectedIndex=0;

region=obj1.options[obj1.selectedIndex].value;

for (i=0;i<Region.split('<').length-1;i++){
obj3.options=new Option(Region.split('<')[i+1].split('>')[1],Region.split('<')[i+1].split('>')[1],true,true);
}

obj3.selectedIndex=0;

}

</script>

BillyRayPreachersSon · Mar 3, 2005

Two requests:

1. Post your code within "code" TGML tags (see the "Process TGML" link below the posting box, and

2. Post the client-side code, not the server-side code. It would be easier to work with.

Dan

The answers you get are only as good as the information you give!

Moonpie10 · Mar 4, 2005

..below is the view source code...

Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[URL unfurl="true"]http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">[/URL]
<html xmlns="[URL unfurl="true"]http://www.w3.org/1999/xhtml">[/URL]
<!-- InstanceBegin template="/Templates/header_contentpane_contentarea.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="content-type" content="text/html;charset=utf-8" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Partner Geography</title>
<!-- InstanceEndEditable -->
<style type="text/css">@import "/partnerDB/assets/default.css";</style>
<style type="text/css" media="print">@import "/partnerDB/assets/print.css";</style>
<script src="/partnerDB/assets/scripts.js" type="text/javascript"></script>
<script src="/partnerDB/assets/overlib.js" type="text/javascript"></script>
<script src="/partnerDB/assets/local_navigation.js" type="text/javascript"></script>
<script src="/partnerDB/assets/choice.js" type="text/javascript"></script>
<!-- InstanceBeginEditable name="head" -->
<script src="/partnerDB/assets/table_controls.js" type="text/javascript"></script>
<script type="text/javascript">
</script>
</head>



<script language="javascript"> 

Africa=' <option value="AL">Alberta<option value="BC">British Columbia<option value="MN">Manitoba<option value="NW">NW Territory<option value="NA">National<option value="NB">New Brunswick<option value="NF">Newfoundland<option value="NS">Nova Scotia<option value="NU">Nunavut<option value="ON">Ontario<option value="PE">Prince Edward Island<option value="QE">Quebec<option value="SP">Saint Pierre & Miquelon<option value="SA">Saskatchewan<option value="YU">Yukon';
AsiaPacific=' <option value="AL">Alberta<option value="BC">British Columbia<option value="MN">Manitoba<option value="NW">NW Territory<option value="NA">National<option value="NB">New Brunswick<option value="NF">Newfoundland<option value="NS">Nova Scotia<option value="NU">Nunavut<option value="ON">Ontario<option value="PE">Prince Edward Island<option value="QE">Quebec<option value="SP">Saint Pierre & Miquelon<option value="SA">Saskatchewan<option value="YU">Yukon';
Canada=' <option value="AL">Alberta<option value="BC">British Columbia<option value="MN">Manitoba<option value="NW">NW Territory<option value="NA">National<option value="NB">New Brunswick<option value="NF">Newfoundland<option value="NS">Nova Scotia<option value="NU">Nunavut<option value="ON">Ontario<option value="PE">Prince Edward Island<option value="QE">Quebec<option value="SP">Saint Pierre & Miquelon<option value="SA">Saskatchewan<option value="YU">Yukon';
Europe=' <option value="AL">Alberta<option value="BC">British Columbia<option value="MN">Manitoba<option value="NW">NW Territory<option value="NA">National<option value="NB">New Brunswick<option value="NF">Newfoundland<option value="NS">Nova Scotia<option value="NU">Nunavut<option value="ON">Ontario<option value="PE">Prince Edward Island<option value="QE">Quebec<option value="SP">Saint Pierre & Miquelon<option value="SA">Saskatchewan<option value="YU">Yukon';
LatinAmerica=' <option value="AL">Alberta<option value="BC">British Columbia<option value="MN">Manitoba<option value="NW">NW Territory<option value="NA">National<option value="NB">New Brunswick<option value="NF">Newfoundland<option value="NS">Nova Scotia<option value="NU">Nunavut<option value="ON">Ontario<option value="PE">Prince Edward Island<option value="QE">Quebec<option value="SP">Saint Pierre & Miquelon<option value="SA">Saskatchewan<option value="YU">Yukon';
MiddleEast=' <option value="AL">Alberta<option value="BC">British Columbia<option value="MN">Manitoba<option value="NW">NW Territory<option value="NA">National<option value="NB">New Brunswick<option value="NF">Newfoundland<option value="NS">Nova Scotia<option value="NU">Nunavut<option value="ON">Ontario<option value="PE">Prince Edward Island<option value="QE">Quebec<option value="SP">Saint Pierre & Miquelon<option value="SA">Saskatchewan<option value="YU">Yukon';
UnitedStates=' <option value="AL">Alabama<option value="AK">Alaska<option value="AZ">Arizona<option value="AR">Arkansas<option value="CA">California<option value="CO">Colorado<option value="CT">Connecticut<option value="DE">Delaware<option value="FL">Florida<option value="GA">Georgia<option value="HI">Hawaii<option value="ID">Idaho<option value="IL">Illinois<option value="IN">Indiana<option value="IA">Iowa<option value="KS">Kansas<option value="KY">Kentucky<option value="LA">Louisiana<option value="ME">Maine<option value="MD">Maryland<option value="MA">Massachusetts<option value="MI">Michigan<option value="MN">Minnesota<option value="MS">Mississippi<option value="MO">Missouri<option value="MT">Montana<option value="NA">National<option value="NE">Nebraska<option value="NV">Nevada<option value="NH">New Hampshire<option value="NJ">New Jersey<option value="NM">New Mexico<option value="NY">New York<option value="NC">North Carolina<option value="ND">North Dakota<option value="OH">Ohio<option value="OK">Oklahoma<option value="OR">Oregon<option value="PA">Pennsylvania<option value="RI">Rhode Island<option value="SC">South Carolina<option value="SD">South Dakota<option value="TN">Tennessee<option value="TX">Texas<option value="UT">Utah<option value="VT">Vermont<option value="VA">Virginia<option value="WA">Washington<option value="WV">West Virginia<option value="WI">Wisconsin<option value="WY">Wyoming'; 
Region=' <option value="Canada">Alberta<option value="Canada">British Columbia<option value="UnitedStates">Arkansas<option value="UnitedStates">Connecticut';

function PopulateSelect2(obj1,id2){ 

 if (obj1.selectedIndex<0){ return; } 
 
 obj2=document.getElementById(id2) 
 obj2.options.length=0; 
 
 obj3=document.getElementById("selectedOptions");
 obj3.options.length=0;
 
 ThisString=obj1.options[obj1.selectedIndex].value; 
 ThisString=eval(ThisString); 

 for (i=0;i<ThisString.split('<').length-1;i++){ 
 obj2.options[i]=new Option(ThisString.split('<')[i+1].split('>')[1],ThisString.split('<')[i+1].split('>')[1],true,true); 
 } 

 obj2.selectedIndex=0; 


region=obj1.options[obj1.selectedIndex].value; 

 for (i=0;i<Region.split('<').length-1;i++){ 
 obj3.options[i]=new Option(Region.split('<')[i+1].split('>')[1],Region.split('<')[i+1].split('>')[1],true,true); 
 }  

 obj3.selectedIndex=0;
 
}
  
</script> 

<body>
<div id="banback">
<table id="banutil" border="0" cellpadding="0" cellspacing="0" width="100%"><tr>
<td align="right"><a href="#">Help</a></td>
</tr></table>
<div id="bantran">&nbsp;</div>
<table border="0" cellpadding="0" cellspacing="0" width="100%"><tr valign="middle">
<td id="baninfo" width="100%">Partner Database<span class="mmhide_banwdg">&bull;</span>
<span class="mmhide_bantit">
<script type="text/javascript"><!--
document.write(document.title);
//--></script>
</span></td>
<td><a href="[URL unfurl="true"]http://sww.sas.com"><img[/URL] src="/partnerDB/images/saslogo.gif" border="0" width="62" height="24" hspace="2" vspace="2" alt="SAS" /></a></td>
</tr></table>

<table id="bantabs" border="0" cellpadding="0" cellspacing="0" width="100%"><tr valign="top">
<td class="mmhide_tab1st"><img src="/partnerDB/images/tab_upper_left_first.gif" border="0" width="5" height="5" hspace="0" vspace="0" alt="" /></td>
<td class="mmhide_tablab"><a href="/partnerDB/partners/PartnerSearch.jsp">Partners</a></td>
<td class="mmhide_tabrgt"><img src="/partnerDB/images/tab_upper_right.gif" border="0" width="5" height="5" hspace="0" vspace="0" alt="" /></td>
<td class="mmhide_tablft"><img src="/partnerDB/images/tab_upper_left.gif" border="0" width="5" height="5" hspace="0" vspace="0" alt="" /></td>
<td class="mmhide_tablab"><a href="/partnerDB/reports/Reports.html">Reports</a></td>
<td class="mmhide_tabrgt"><img src="/partnerDB/images/tab_upper_right.gif" border="0" width="5" height="5" hspace="0" vspace="0" alt="" /></td>
<td class="mmhide_tablft"><img src="/partnerDB/images/tab_upper_left.gif" border="0" width="5" height="5" hspace="0" vspace="0" alt="" /></td>
<td class="mmhide_tablab"><a href="/partnerDB/administration/Administration.jsp">Administration</a></td>
<td class="mmhide_tabrgt"><img src="/partnerDB/images/tab_upper_right.gif" border="0" width="5" height="5" hspace="0" vspace="0" alt="" /></td>
<td width="100%">&nbsp;</td>
</tr></table>
</div>
<div id="butbar">
<!-- InstanceBeginEditable name="butbar" -->
<a href="LangProfile.jsp?partID=1215">Language</a>
<a href="IndProfile.jsp?partID=1215">Industry</a>
<a href="SvcProfile.jsp?partID=1215">Services</a>
<a href="OpsysProfile.jsp?partID=1215">OpSys</a>
<a href="SolProfile.jsp?partID=1215">Solutions</a>
<a href="ProdProfile.jsp?partID=1215">SAS Products</a>
<a href="CodeProfile.jsp?partID=1215">Program Code</a>
<a href="DiversityProfile.jsp?partID=1215">Diversity</a>
<a href="GeoProfile.jsp?partID=1215">Geography</a>
<a href="InterfaceProfile.jsp?partID=1215">Interface</a>
<!-- InstanceEndEditable -->
</div>

<table border="0" cellpadding="0" cellspacing="0" width="100%"><tr>

</tr><tr valign="top">

<td id="navcel"><div id="navcol"><!-- #BeginLibraryItem "/library/search.lbi" -->
<div class="mmhide_navhd">
<a href="javascript:navhd_expand_collapse('navhd_search','navhd_search_img');"><img src="../images/collapsesection.gif" id="navhd_search_img" width="12" height="14"  border="0" hspace="0" vspace="0" title="" alt="" style="vertical-align:middle" />&nbsp;Search</a>
</div>
<div id="navhd_search">
<form action="/partnerDB/partners/PartnerSearch.jsp" method="get" id="navsch" onSubmit="return formValidation(this)">
<!--<select name="area" size="1" style="width: 131px">-->
<input type="text" name="query" size="15" class="mmhide_inputtext" />
<input type="hidden" name="stpos" value="0" />
<br>
<input type="submit" value=" Go " onClick="searchFunc()" class="mmhide_btn" onmouseover="hov(this,'mmhide_btn mmhide_btnhov')" onmouseout="hov(this,'mmhide_btn')"/><br />

<!--
<span style="color:#960">Match:
<input type="radio" name="stype" value="AND" id="and" checked="checked" /><label for="and">All</label>
<input type="radio" name="stype" value="OR" id="or" /><label for="or">Any</label></span><br />
-->

</form></div><!-- #EndLibraryItem -->



<div class="mmhide_navhd">
<a href="javascript:navhd_expand_collapse('navhd_areas','navhd_areas_img');"><img src="../images/collapsesection.gif" id="navhd_areas_img" width="12" height="14"  border="0" hspace="0" vspace="0" title="" alt="" style="vertical-align:middle" />&nbsp;Areas</a>
</div>
<div id="navhd_areas">
<ul>
<li><a href="PartnerGeneral.jsp?partID=1215">General</a></li>
<li><a href="PartnerAgree.jsp?partID=1215">Agreements</a></li>
<li><a href="PartnerContact.jsp?partID=1215">Contacts</a></li>
<li><a href="PartnerNotes.jsp?partID=1215">Notes/Correspondence</a></li>
<!-- <li><a href="#">Fees</a></li> -->
<!-- <li><a href="PartnerRenewal.jsp?partID=1215">Renewals</a></li>  -->
<li><a href="PartnerProfile.jsp?partID=1215">Web Profile</a></li>
</ul><!-- #EndLibraryItem --><!-- InstanceEndEditable -->
</div>
<!-- InstanceBeginEditable name="navlinks" --><!-- #BeginLibraryItem "/library/oppRelatedLinks.lbi" -->
<div class="mmhide_navhd">
<a href="javascript:navhd_expand_collapse('navhd_links','navhd_links_img');"><img src="../images/collapsesection.gif" id="navhd_links_img" width="12" height="14"  border="0" hspace="0" vspace="0" title="" alt="" style="vertical-align:middle" />&nbsp;Related Links</a>
</div>
<div id="navhd_links">
<ul>
<li><a href="[URL unfurl="true"]http://dms/EnterCombinedDMS.htm">DMS</a></li>[/URL]
<li>Link2</li>
<li>Link3</li>
</ul>
</div><!-- #EndLibraryItem --><!-- InstanceEndEditable -->
</div></td>
<td id="navwdg"><a href="javascript:navtog()"><img src="images/collapse_button.gif" name="navwdg" border="0" width="11" height="14" hspace="0" vspace="0" alt="" title="Hide Navigation" /></a></td>
<td id="main" width="100%">
<noscript><div class="mmhide_messwarn">
<div class="mmhide_messhd">Warning</div>
<div class="mmhide_messbd">This site's navigation requires Javascript to function. Javascript is disabled on your browser; please enable it in order to access all pages.</div>
</div></noscript>
<h1>
<script type="text/javascript"><!--
document.write(document.title);
//--></script>
</h1>

</html>


<form name="geo" action="/partnerDB/servlet/editGeoProfile" method="post" onSubmit="populateRegion(availableOptions,Region);populateHidden(selectedOptions,hidden1)"; style="margin:0">


<div id="mainentity"><!-- #BeginLibraryItem "/library/oppEntityHeader.lbi" -->
<div class="section">
<div class="sectionheader">
<div class="sectionheadertext">
<a href="javascript:expand_collapse('general','general_img');"><img src="../images/collapsesection.gif" id="general_img" width="12" height="14"  border="0" hspace="0" vspace="0" title="" alt="" style="vertical-align:middle" />&nbsp;Geography</a>
</div>
<div class="sectionbody" id="general">
<div class="formfields">
<table border="0" cellpadding="0" cellspacing="0">

    
 <tr>
	Region

	<td><select size="10" name="availableOptions" onchange="javascript:PopulateSelect2(availableOptions,'Select2');" > 
	 <option value="Africa">Africa<option value="AsiaPacific">AsiaPacific<option value="Canada">Canada<option value="Europe">Europe<option value="LatinAmerica">LatinAmerica<option value="MiddleEast">MiddleEast<option value="UnitedStates">UnitedStates
	</select> </td>
	
	<td>&nbsp;&nbsp;<select id="Select2" name="Select2" size="10" multiple > 
	</select></td>
         
       <td valign="top">
       <td class="tableimgcol" width="40" onClick="copySelected(Select2,selectedOptions)"><img src="/partnerDB/images/ArrowRightAdd.gif">
       <br><onClick="copyAll(Select2,selectedOptions)"><img src="/partnerDB/images/ArrowDoubleRight.gif">
        <br>            	        
        <br>
       <td class="tableimgcol" width="40" onClick="remSelected(selectedOptions,Select2)"><img src="/partnerDB/images/ArrowLeftRemove.gif">
       <br><onClick="remAll(selectedOptions,Select2)"><img src="/partnerDB/images/ArrowDoubleLeft.gif">
 
       </td>
 	
       <td><select id="selectedOptions" name="selectedOptions" multiple size="10">  
       </select></td>
      </tr>

</table>
</div>
</div>
</div>

<input type="hidden" name="partID" value="1215">
<input type="hidden" name="hidden1" >
<input type="hidden" name="Region" >

<div class="dialogbuttons">
  <!-- InstanceBeginEditable name="dialogbuttons" -->
  <input type="submit" value="   OK    " class="mmhide_btn" onmouseover="hov(this,'mmhide_btn mmhide_btnhov')" onmouseout="hov(this,'mmhide_btn')" />
  <input type="button" value=" Cancel  " class="mmhide_btn" onmouseover="hov(this,'mmhide_btn mmhide_btnhov')" onmouseout="hov(this,'mmhide_btn')" onclick="window.location.href='GeoProfile.jsp?partID=1215'" />
</div>
</div>  
  

<!-- InstanceEndEditable -->
<!-- NOSEARCH 2 BEG -->
</td>
</tr></table>
<script type="text/javascript"><!--
navset();
//--></script>
 
</form></body></html>

Moonpie10 · Mar 4, 2005

Got it! Thanks for your time.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Parse a String?

Moonpie10

Programmer

BillyRayPreachersSon

Programmer

Moonpie10

Programmer

Moonpie10

Programmer

Similar threads

Part and Inventory Search

Sponsor