Populating Second Listbox

jack-b · Jul 3, 2006

Hi,

I have a list box which displays countries names and a second listbox
which displays their cites (based on the selection made in ListBox 1)

If the user selects USA i want to display cities in the States - if the
user selects multiple countries I want to display the cities in ALL the
selected counties e.g. a user select US and England, the second list
would display ally cities in England and all the cities in the US.

I am new to javascript so would appreciate any help.

Krij · Jul 3, 2006

Hi!

I solved a similar situation like this: When user picks an item in
lstCategory, lstItemDetail will be populated by:

With Me!lstItemDetail
.RowSource = ""
.ColumnCount = 4
.ColumnWidths = "0cm;7cm;2cm;0cm"
.BoundColumn = 1
.RowSource = "SELECT ItemID,ItemName,ItemPrice,CategoryID " _
& "FROM tblItems " _
& "WHERE (((CategoryID) = Forms!frmItems!lstCategory)) " _
& "ORDER BY ItemName;"

This was done in ms access 2000. And I suppose that you have country in
one table and cities in another with a relation between them.

Hope this helps

(e-mail address removed) skrev:

jack-b · Jul 3, 2006

Hi,
Thanks for your help but I was really looking for a javascript
solution. I have been able to solve this using a postback to the
server.

Can anyone help??

Dr John Stockton · Jul 3, 2006

JRS: In article <[email protected]>,
dated Sun, 2 Jul 2006 23:43:26 remote, seen in
news:comp.lang.javascript, (e-mail address removed) posted :

I have a list box which displays countries names and a second listbox
which displays their cites (based on the selection made in ListBox 1)

If the user selects USA i want to display cities in the States - if the
user selects multiple countries I want to display the cities in ALL the
selected counties e.g. a user select US and England, the second list
would display ally cities in England and all the cities in the US.

Do you consider it reasonable to impose on unsuspecting users, who on
the WWW will not necessarily be using broadband landline, the burden of
downloading the names of all the cities in the world?

jack-b · Jul 4, 2006

It's totally irrelevant on what the values represent! I take it you
don't know the answer? I was actually using the country/city scenario
as an example because it made the question clear.

Krij · Jul 4, 2006

(e-mail address removed) skrev:

It's totally irrelevant on what the values represent! I take it you
don't know the answer? I was actually using the country/city scenario
as an example because it made the question clear.

Sorry....I was in the wrong group and my brain stopped functioning for
a second or two...

Danny · Jul 4, 2006

This is an old example I made:
------------------------
<html>
<head> <title>none </title>

<script type="text/javascript">
var seafood=['shrimp','guppi','lobster','catfish'];
var foodtype=['italian','thai','chinese'];
var hardware=['pci peripherals','agps','cases','keyboards','mice','network cables'];

function getList(el,el2) {

itemChosen=window[el.options[el.selectedIndex].value];
if (el.selectedIndex==0) return; // 1st option in 1stlist is the header
el2.length=0; // to reset the 2nd select

for (i=0;i<itemChosen.length;i++) {
newOpt=new Option(itemChosen,'this is '+itemChosen); // 1st argument is
the text to show, 2nd is the value for it if any
el2.options[el2.length]=newOpt; // adds it
}

}

</script>

</head>
<body style="margin: 4em">

<form>

<select name="upperList" onchange="getList(this,this.form.belowList)">
<option value="">--- choose below ---</option>
<option value="seafood">want seafood </option>
<option value="foodtype">what food type </option>
<option value="hardware">hardware </option>
</select>

<select name="belowList" onchange="alert(this.options[this.selectedIndex].value)">
<option value=""> </option>
</select>

<textarea onkeydown="(this.value.length>=200) ? return true : return false" name="s1"
cols="48" rows="4" ></textarea>
</form>

</body>
</html>

--------------------

bear in mind that I use arrays for the variables to be used to populate the Select "belowList",
now, for UK/US cities populating, that will be a huge array , and you most likely will break
it down to counties/provinces/locales and such, so, the same applies, using an array, BUT do
asynchronous calls to the server upon the user selecting anything, so the list of the items to
be used, AND inserted as the arrays content, are fetched from the server only on a
user-selection basis, that way you don't preload everything and bogdown the page loading. To
make asynchronous calls check some premade sets on so-called Ajax.

Danny

Matt Kruse · Jul 4, 2006

Thanks for your help but I was really looking for a javascript
solution.

http://www.javascripttoolbox.com/lib/dynamicoptionlist/

jack-b · Jul 9, 2006

Thanks guys, exactly what i was looking for.

Matt said:
http://www.javascripttoolbox.com/lib/dynamicoptionlist/

Filter table rows based on multiple checkboxes value	2	Jan 13, 2023
Angularjs newbie - second JSON datasource does not display	0	May 18, 2022
Unselect one listbox when second is selected	1	Sep 23, 2008
Getting the listbox object	7	Jun 25, 2011
DropDownList AppendDataBoundItems problem	2	Jun 5, 2007
Populating a text box with a value from a function	1	Mar 16, 2006
Help me fix this bug in my program! Displaying chart data	1	Apr 8, 2023
dependent drop down list (pre-filled from XML file)	0	Jul 19, 2006

Populating Second Listbox

jack-b

Krij

jack-b

Dr John Stockton

jack-b

Krij

Danny

Matt Kruse

jack-b

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads