anup101
asked on
linking one listbox with other
how to populate one listbox from the database on the change of data in another databox then on the change of the second the third should be populatedfor eg
if one listbox contains three practices namely x,y,z on choosing x a query should be sent to the database and should then populate the database with the names of people working in that practice.then on choosing one name from the list another listbox should be populated with his managers name(using asp)
if one listbox contains three practices namely x,y,z on choosing x a query should be sent to the database and should then populate the database with the names of people working in that practice.then on choosing one name from the list another listbox should be populated with his managers name(using asp)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If the first selection is of ...
Choose an option
Starsign
Gender
Salary
And you are changing the second list box to show appropriate options ...
Gender (Male, Female)
Salary (<$10K,$10K - $20K, $20K - $30K, $30K - $40K, $40K+)
Birthsign (Aries, Libra, Aquarius, Leo, Cancer, Capricorn, Virgo, Gemini, Picses, Sagittarius, Taurus, Scorpio)
If you choose Starsign first, you will end up with 12 options in the second select.
If you then alter the first select to Gender you only have 2 options.
Can you remove the remaining, unused options in the second select?
option.free?
option = nul/nil/0?
(Just a question, not testing or anything!)
Richard.
Choose an option
Starsign
Gender
Salary
And you are changing the second list box to show appropriate options ...
Gender (Male, Female)
Salary (<$10K,$10K - $20K, $20K - $30K, $30K - $40K, $40K+)
Birthsign (Aries, Libra, Aquarius, Leo, Cancer, Capricorn, Virgo, Gemini, Picses, Sagittarius, Taurus, Scorpio)
If you choose Starsign first, you will end up with 12 options in the second select.
If you then alter the first select to Gender you only have 2 options.
Can you remove the remaining, unused options in the second select?
option.free?
option = nul/nil/0?
(Just a question, not testing or anything!)
Richard.
yes, as I did in the reloadCities function above ...
first set options.length to zero, thus deleting all the options, then add the new options.
first set options.length to zero, thus deleting all the options, then add the new options.
Oh yes! Thanks! Not my question either!
Ha! Free!!!!
Ha! Free!!!!
anup101, did this help you?
This question has been abandoned. I will make a recommendation to the
moderators on its resolution in a week or two. I appreciate any comments
that would help me to make a recommendation.
<note>
In the absence of responses, I may recommend DELETE unless it is clear
to me that it has value as a PAQ. Silence = you don't care
</note>
Cd&
moderators on its resolution in a week or two. I appreciate any comments
that would help me to make a recommendation.
<note>
In the absence of responses, I may recommend DELETE unless it is clear
to me that it has value as a PAQ. Silence = you don't care
</note>
Cd&
The points should go to knightEknight. His answer is more than adequate to acheive the desired results.
<HTML>
<HEAD>
<TITLE>Dynamic SELECTs</title>
<SCRIPT language='JavaScript'>
<!-- //
// create js arrays to hold the data for selCity
var aryCityData = new Array();
aryCityData[0] = new Array();
aryCityData[0][0] = new Option('Select a State','0');
aryCityData[1] = new Array();
aryCityData[1][0] = new Option('Los Angeles','301');
aryCityData[1][1] = new Option('Oakland','304');
aryCityData[1][2] = new Option('Rio Linde','305');
aryCityData[1][3] = new Option('San Diego','302');
aryCityData[1][4] = new Option('San Fransisco','303');
aryCityData[2] = new Array();
aryCityData[2][0] = new Option('Miami','101');
aryCityData[2][1] = new Option('Orlando','102');
aryCityData[2][2] = new Option('Tampa','103');
aryCityData[3] = new Array();
aryCityData[3][0] = new Option('Abilene','201');
aryCityData[3][1] = new Option('Austin','202');
aryCityData[3][2] = new Option('Dallas','203');
aryCityData[3][3] = new Option('Houston','204');
function reloadCities(curStateIndex
{
if ( curStateIndex < 0 ) return; // no state selected, so do nothing
var aryCityOpts = document.myform.selCity.op
aryCityOpts.length=0; // first, clear the current City options ...
// then re-load the City options with values for the current State
for ( var i=0,n=aryCityData[curState
{
//// the line below no longer works in IE5 (it works in IE4 and NS4+).
// aryCityOpts[aryCityOpts.le
//// therefore, it now takes three lines to do the same thing:
aryCityOpts.length++; // add a new Option, then put data in it (below)
aryCityOpts[aryCityOpts.le
aryCityOpts[aryCityOpts.le
}
}
// -->
</script>
</head>
<BODY onLoad='document.myform.se
<FORM name='myform' method='post' action='whatever.asp' onSubmit='return(false);'>
State:
<SELECT name='selState' size='1' onChange='reloadCities(thi
<OPTION value='0'></option>
<OPTION value='30'>California</opt
<OPTION value='10'>Florida</option
<OPTION value='20'>Texas</option>
</select><P>
City:
<SELECT name='selCity' size='1' onChange='alert(this.optio
<OPTION value=''>Select a State</option>
<OPTION></option>
<OPTION></option>
<OPTION></option>
</select><P>
</form>
</body>
</html>