Help !! Populate Drop down list

HOTLIPS · Jul 3, 2003

Hi
I want to dynamically populate a drop down list from a list of names.........I would like to select, say all names beginning with a particular letter and filter those names out and dynamically populate the dropdown selection list....and then be able to select a name from the filtered list.
vis :
I would like letters of alphabet on page... when clicking a letter...the selection list would only show those names beginning with that particular letter..... in other words it would be minimizing the selection list.

Can Any one help ?????

Hotlips

mwolf00 · Jul 3, 2003

function loadSelect(letter){
sList = document.getElementById("mySelect&quot

//clear select first
for (x=1; x<sList.options.length; x++){
sList.options[x] = null
}
//now load list
var listCount = 0
for(x=0; x<allNames.length; x++){
if(allNames[x].substr(0,1) == letter){
sList.options[listCount] = new Option(allNames[x], allNames[x])
listCount ++
}
}
}
</script>
<body onLoad="loadSelect('A')">
<form name="myForm">
<select name="mySelect" id="mySelect"><option></select>
</form>
<br>
<a href="javascript: loadSelect('A')">A</a>
<br>
<a href="javascript: loadSelect('B')">B</a>
<br>
<a href="javascript: loadSelect('C')">C</a>
<br>

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

adam0101 · Jul 3, 2003

Here's an addition to mwolf00's script to help write out all those links:

Code:

<script>
var alphabet=&quot;ABCDEFGHIJKLMNOPQRSTUVWXYZ&quot;;
for(var i=0;i<26;i++){
  document.writeln(&quot; <a href=\&quot;javascript:loadSelect('&quot;+alphabet.charAt(i)+&quot;')\&quot;>&quot;+alphabet.charAt(i)+&quot;</a> &quot;+(i!=25?'|':''));
}
</script>

Adam
while(woman.width>woman.height && wallet.value>0){beer++;vision.blur()};

HOTLIPS · Jul 4, 2003

Many thanks to u both

Hotlips

HOTLIPS · Jul 4, 2003

Hi again
Got a bit of a problem......
when I select a letter and minimise the list...say a list of 20 names beginning with H.... then I select a letter ....say G and only 5 names .... there is a mixed list of G names and H names.... is there any way to clear the list and only show the names beginning with that particular letter selected.....
And if I select say X.... and there are no names beginning with X then the list should be blank
Can u help ???

Hotlips

mwolf00 · Jul 7, 2003

This bit of code (already in the script) should be doing that....

//clear select first
for (x=1; x<sList.options.length; x++){
sList.options[x] = null
}

If you run my code as posted and click on "C" the list only has 2 names on it after having 3 "A" names....

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

HOTLIPS · Jul 8, 2003

Thanks for that ... maybe I am nitpicking.. but look at my code and u will see what I mean... click B then try E... the names are mixed.....

<script>
var allNames = new Array();
allNames[0] =""
allNames[1] ="8t25"
allNames[2] ="Abbott A W"
allNames[3] ="Allport B"
allNames[4] ="Andrews P"
allNames[5] ="Antcliffe D"
allNames[6] ="Apps C"
allNames[7] ="Armstrong D"
allNames[8] ="Ashurst N"
allNames[9] ="Atherton H"
allNames[10] ="Bailey G"
allNames[11] ="Bailey R"
allNames[12] ="Baker G"
allNames[13] ="Baker K"
allNames[14] ="Ball R"
allNames[15] ="Ballantyne J"
allNames[16] ="Bannister D"
allNames[17] ="Bannister F"
allNames[18] ="Bell A"
allNames[19] ="Bell R"
allNames[20] ="Beswick H"
allNames[21] ="Beswick K"
allNames[22] ="Blair J"
allNames[23] ="Blakely"
allNames[24] ="Blakely R"
allNames[25] ="Blundell A"
allNames[26] ="Boyack I"
allNames[27] ="Bradford Stores"
allNames[28] ="Bramhall C"
allNames[29] ="Brannigan J"
allNames[30] ="Bremner A"
allNames[31] ="Brown A"
allNames[32] ="Brown C"
allNames[33] ="Brown H M"
allNames[34] ="Brown I"
allNames[35] ="Brown I R"
allNames[36] ="Budenburg"
allNames[37] ="Bulley P."
allNames[38] ="Bulmer S"
allNames[39] ="Burdis R"
allNames[40] ="Butcher C"
allNames[41] ="Butler M"
allNames[42] ="Cameron D"
allNames[43] ="Chandon Singh"
allNames[44] ="Chandrasergan V"
allNames[45] ="Chapman J"
allNames[46] ="Cherry S"
allNames[47] ="Chislett R"
allNames[48] ="Clark J"
allNames[49] ="Clarke R"
allNames[50] ="Clarke W A"
allNames[51] ="Clements S"
allNames[52] ="Coblenz E"
allNames[53] ="Coblenz R"
allNames[54] ="Cochran B"
allNames[55] ="Cochrane J"
allNames[56] ="Colley S S"
allNames[57] ="Connel P"
allNames[58] ="Connelly T"
allNames[59] ="Cooper P"
allNames[60] ="Cormac A"
allNames[61] ="Coughlin J"
allNames[62] ="Cowan D"
allNames[63] ="Cowie C"
allNames[64] ="Crane B"
allNames[65] ="Crawford A"
allNames[66] ="Crawley P"
allNames[67] ="Creed S"
allNames[68] ="Creek G"
allNames[69] ="Crichton C"
allNames[70] ="Crogan M"
allNames[71] ="Cunningham W"
allNames[72] ="Cutler H"
allNames[73] ="Dadd A"
allNames[74] ="Dastl E"
allNames[75] ="Davis A C"
allNames[76] ="Davis S"
allNames[77] ="Davison S"
allNames[78] ="Derby"
allNames[79] ="Devlin K"
allNames[80] ="Dew J"
allNames[81] ="Diamond J"
allNames[82] ="Dickson J"
allNames[83] ="Docking F"
allNames[84] ="Dodd D"
allNames[85] ="Domzalski M"
allNames[86] ="Dowds P"
allNames[87] ="Dowell P"
allNames[88] ="Dowling P"
allNames[89] ="Drakelow"
allNames[90] ="Elder J"
allNames[91] ="Farr R"
allNames[92] ="Fay K"
allNames[93] ="Fay P"
allNames[94] ="Fearn A"
allNames[95] ="Fell M"
allNames[96] ="Fenwick N"
allNames[97] ="Foreman W"
allNames[98] ="Fretwell T"
allNames[99] ="Galagher H"
allNames[100] ="Garside M R"
allNames[101] ="Gibson P"
allNames[102] ="Glaze J"
allNames[103] ="Goldshaw S"
allNames[104] ="Goodchild P"
allNames[105] ="Gray D"
allNames[106] ="Greensmith R"
allNames[107] ="Griffin B"
allNames[108] ="Grundy B"
allNames[109] ="Gultig W"
allNames[110] ="Gunning G"
allNames[111] ="Haddock P"
allNames[112] ="Haddow B"
allNames[113] ="Hagan J"
allNames[114] ="Hall M"
allNames[115] ="Halliday S"
allNames[116] ="Hampshire D M"
allNames[117] ="Hannett B"
allNames[118] ="Hardy G"
allNames[119] ="Hari Krishana"
allNames[120] ="Hari Rao Krish"
allNames[121] ="Harpham S"
allNames[122] ="Harrison S."
allNames[123] ="Harvey TD"
allNames[124] ="Hebburn Stores"
allNames[125] ="Henry Colin"
allNames[126] ="Hensby C"
allNames[127] ="Herbert O"
allNames[128] ="Herrity R"
allNames[129] ="Hewling K"
allNames[130] ="Hill D"
allNames[131] ="Hillman B"
allNames[132] ="Hilyer J"
allNames[133] ="Holdsworth T"
allNames[134] ="Hopkins B"
allNames[135] ="Hughes A"
allNames[136] ="Hughes P"
allNames[137] ="Isaacs S"
allNames[138] ="Jackson M"
allNames[139] ="James R"
allNames[140] ="Jamieson T"
allNames[141] ="Jarnie D"
allNames[142] ="Jones C"
allNames[143] ="Jones G"
allNames[144] ="Jones M."
allNames[145] ="Jones S"
allNames[146] ="Joyce T"
allNames[147] ="Kamaladoss B"
allNames[148] ="Keigan K"
allNames[149] ="Kemp N"
allNames[150] ="Kesdby"
allNames[151] ="Key M"
allNames[152] ="Kidd M"
allNames[153] ="King B"
allNames[154] ="Kirkley V J"
allNames[155] ="Kirkup S"
allNames[156] ="Kit 23"
allNames[157] ="Kit 24"
allNames[158] ="Kitchen"
allNames[159] ="Klofta E"
allNames[160] ="Klyn M"
allNames[161] ="Knowles J"
allNames[162] ="Laffey L"
allNames[163] ="Laing D"
allNames[164] ="Lamont T"
allNames[165] ="Laws J"
allNames[166] ="Lear S"
allNames[167] ="Leeds Stores"
allNames[168] ="Lenney D"
allNames[169] ="Leyland I"
allNames[170] ="Lindsay N"
allNames[171] ="Livingstone I"
allNames[172] ="Major M"
allNames[173] ="Manufacturer"
allNames[174] ="Marchant M"
allNames[175] ="Marjoram P"
allNames[176] ="Marshall C"
allNames[177] ="Marshall S C"
allNames[178] ="Marsland J"
allNames[179] ="Martin B"
allNames[180] ="Maskell K"
allNames[181] ="Mason J"
allNames[182] ="Mason P"
allNames[183] ="Mc Lean R."
allNames[184] ="McCabe S"
allNames[185] ="McCollum C J"
allNames[186] ="McDonald D"
allNames[187] ="McGeagh D"
allNames[188] ="McGeough D"
allNames[189] ="McGourley E"
allNames[190] ="McIntyre W"
allNames[191] ="McKenzie C"
allNames[192] ="McKenzie M"
allNames[193] ="McMahon C"
allNames[194] ="McMahon W"
allNames[195] ="McMenamin D"
allNames[196] ="McPhearson K"
allNames[197] ="McQuire B"
allNames[198] ="Meakin P"
allNames[199] ="Miller R"
allNames[200] ="Mitchell T.D"
allNames[201] ="Moody M"
allNames[202] ="Moody N"
allNames[203] ="Moore P"
allNames[204] ="Moorhouse D"
allNames[205] ="Moorhouse P"
allNames[206] ="Moran P"
allNames[207] ="Morrow A."
allNames[208] ="Munro A"
allNames[209] ="Munro JJ"
allNames[210] ="Murphy P"
allNames[211] ="Napper A"
allNames[212] ="Naveet J"
allNames[213] ="Nelson E"
allNames[214] ="Nesbitt C"
allNames[215] ="Nesbitt K"
allNames[216] ="Nesbitt M"
allNames[217] ="Newby J D"
allNames[218] ="Nicdao F"
allNames[219] ="Nichols C"
allNames[220] ="Nicholson J S"
allNames[221] ="Not. Allocated"
allNames[222] ="O'Brien A"
allNames[223] ="O'Hare T"
allNames[224] ="Oakes J G"
allNames[225] ="Obradovic M"
allNames[226] ="Oley H"
allNames[227] ="Padhye R"
allNames[228] ="Panametrics"
allNames[229] ="Parker B"
allNames[230] ="Parker G"
allNames[231] ="Patterson D"
allNames[232] ="Patterson K"
allNames[233] ="Patterson M"
allNames[234] ="Pearson S G"
allNames[235] ="Piggin S"
allNames[236] ="Platts J"
allNames[237] ="Pritchard A"
allNames[238] ="Prout P"
allNames[239] ="Pullman"
allNames[240] ="Quarantine"
allNames[241] ="RAO KHK"
allNames[242] ="Radhakrishnan S"
allNames[243] ="Redshaw S"
allNames[244] ="Reed F"
allNames[245] ="Reed Les"
allNames[246] ="Reed P"
allNames[247] ="Renwick R"
allNames[248] ="Richardson C"
allNames[249] ="Ridge E"
allNames[250] ="Roberts D"
allNames[251] ="Roberts S."
allNames[252] ="Roberts T"
allNames[253] ="Robertson S"
allNames[254] ="Robinson D"
allNames[255] ="Robinson K"
allNames[256] ="Robson S"
allNames[257] ="Rogers G"
allNames[258] ="Rumbold D"
allNames[259] ="Scholey M"
allNames[260] ="Sharp B"
allNames[261] ="Singh C"
allNames[262] ="Skene G"
allNames[263] ="Skinner M"
allNames[264] ="Snowdon R"
allNames[265] ="Sotheran G"
allNames[266] ="Stokes P"
allNames[267] ="Stores"
allNames[268] ="Summers B"
allNames[269] ="Sunda"
allNames[270] ="Sundarajan"
allNames[271] ="Surtees S"
allNames[272] ="Swainston R"
allNames[273] ="Szymonowicz A"
allNames[274] ="Taggart E"
allNames[275] ="Tait A"
allNames[276] ="Tambourrini P"
allNames[277] ="Taylor A"
allNames[278] ="Taylor Tony"
allNames[279] ="Temple G"
allNames[280] ="Test"
allNames[281] ="Thallis C agent"
allNames[282] ="Thomas D"
allNames[283] ="Thomas N"
allNames[284] ="Thompson C"
allNames[285] ="Thompson N"
allNames[286] ="Thompson R W"
allNames[287] ="Thompson S"
allNames[288] ="Tiernan M"
allNames[289] ="Timms I G"
allNames[290] ="Tipton N"
allNames[291] ="Turnbull B"
allNames[292] ="Unknown"
allNames[293] ="Vardy R"
allNames[294] ="Venkadesh K"
allNames[295] ="Vickors G"
allNames[296] ="Villamangna N"
allNames[297] ="Vinton S"
allNames[298] ="Waddacor N"
allNames[299] ="Wade B W"
allNames[300] ="Waistell A"
allNames[301] ="Walsh C N"
allNames[302] ="Ward J"
allNames[303] ="Warin G"
allNames[304] ="Warren D"
allNames[305] ="Warren J"
allNames[306] ="Wasson D"
allNames[307] ="Watson Phil"
allNames[308] ="Webb P"
allNames[309] ="Westcott T"
allNames[310] ="Wheatcroft S"
allNames[311] ="Wheatley P"
allNames[312] ="Whing K"
allNames[313] ="White S"
allNames[314] ="Wiblin T"
allNames[315] ="Wiffin D"
allNames[316] ="Wilkins B"
allNames[317] ="Wilkinson J"
allNames[318] ="Williams D"
allNames[319] ="Wilson B"
allNames[320] ="Wilson K"
allNames[321] ="Wilson P"
allNames[322] ="Workshop"
allNames[323] ="Workshop Office"
allNames[324] ="Wright C"
allNames[325] ="Wright S"
allNames[326] ="Wyatt J"
allNames[327] ="Young E"

//allNames = new Array("Adam","Albert","Andrea","Bill","Barb","Betty","Chris","Carl&quot

function loadSelect(letter){
sList = document.getElementById("mySelect&quot

//clear select first
for (x=1; x<sList.options.length; x++){
sList.options[x] = null
}
//now load list
var listCount = 0
for(x=0; x<allNames.length; x++){
if(allNames[x].substr(0,1) == letter){
sList.options[listCount] = new Option(allNames[x], allNames[x])
listCount ++
}
}
}

var alphabet="ABCDEFGHIJKLMNOPQRSTUVWXYZ";
for(var i=0;i<26;i++){
document.writeln(" <a href=\"javascript:loadSelect('"+alphabet.charAt(i)+"')\">"+alphabet.charAt(i)+"</a> "+(i!=25?'|':''));
}

</script>
<body onLoad="loadSelect('A')">
<form name="myForm">
<select multiple size=7 name="mySelect" id="mySelect"><option></select>
</form>
<br>
</body>

Many Thanks
Hotlips

HOTLIPS · Jul 8, 2003

Thanks for that ... maybe I am nitpicking.. but look at my code and u will see what I mean.... I have had to cut down on the list ...but try click B then try E... the names are mixed.....

<script>
var allNames = new Array();
allNames[0] =""
allNames[1] ="8t25"
allNames[2] ="Abbott A W"
allNames[3] ="Allport B"
allNames[4] ="Andrews P"
allNames[5] ="Antcliffe D"
allNames[6] ="Apps C"
allNames[7] ="Armstrong D"
allNames[8] ="Ashurst N"
allNames[9] ="Atherton H"
allNames[10] ="Bailey G"
allNames[11] ="Bailey R"
allNames[12] ="Baker G"
allNames[13] ="Baker K"
allNames[14] ="Ball R"
allNames[15] ="Ballantyne J"
allNames[16] ="Bannister D"
allNames[17] ="Bannister F"
allNames[18] ="Bell A"
allNames[19] ="Bell R"
allNames[20] ="Beswick H"
allNames[21] ="Beswick K"
allNames[22] ="Blair J"
allNames[23] ="Blakely"
allNames[24] ="Blakely R"
allNames[25] ="Blundell A"
allNames[26] ="Boyack I"
allNames[27] ="Bradford Stores"
allNames[28] ="Bramhall C"
allNames[29] ="Brannigan J"
allNames[30] ="Bremner A"
allNames[31] ="Brown A"
allNames[32] ="Brown C"
allNames[33] ="Brown H M"
allNames[34] ="Brown I"
allNames[35] ="Brown I R"
allNames[36] ="Budenburg"
allNames[37] ="Bulley P."
allNames[38] ="Bulmer S"
allNames[39] ="Burdis R"
allNames[40] ="Butcher C"
allNames[41] ="Butler M"
allNames[42] ="Cameron D"
allNames[43] ="Chandon Singh"
allNames[44] ="Chandrasergan V"
allNames[45] ="Chapman J"
allNames[46] ="Cherry S"
allNames[47] ="Chislett R"
allNames[48] ="Clark J"
allNames[49] ="Clarke R"
allNames[50] ="Clarke W A"
allNames[51] ="Clements S"
allNames[52] ="Coblenz E"
allNames[53] ="Coblenz R"
allNames[54] ="Cochran B"
allNames[55] ="Cochrane J"
allNames[56] ="Colley S S"
allNames[57] ="Connel P"
allNames[58] ="Connelly T"
allNames[59] ="Cooper P"
allNames[60] ="Cormac A"
allNames[61] ="Coughlin J"
allNames[62] ="Cowan D"
allNames[63] ="Cowie C"
allNames[64] ="Crane B"
allNames[65] ="Crawford A"
allNames[66] ="Crawley P"
allNames[67] ="Creed S"
allNames[68] ="Creek G"
allNames[69] ="Crichton C"
allNames[70] ="Crogan M"
allNames[71] ="Cunningham W"
allNames[72] ="Cutler H"
allNames[73] ="Dadd A"
allNames[74] ="Dastl E"
allNames[75] ="Davis A C"
allNames[76] ="Davis S"
allNames[77] ="Davison S"
allNames[78] ="Derby"
allNames[79] ="Devlin K"
allNames[80] ="Dew J"
allNames[81] ="Diamond J"
allNames[82] ="Dickson J"
allNames[83] ="Docking F"
allNames[84] ="Dodd D"
allNames[85] ="Domzalski M"
allNames[86] ="Dowds P"
allNames[87] ="Dowell P"
allNames[88] ="Dowling P"
allNames[89] ="Drakelow"
allNames[90] ="Elder J"
allNames[91] ="Farr R"
allNames[92] ="Fay K"
allNames[93] ="Fay P"
allNames[94] ="Fearn A"
allNames[95] ="Fell M"
allNames[96] ="Fenwick N"
allNames[97] ="Foreman W"
allNames[98] ="Fretwell T"
allNames[99] ="Galagher H"
allNames[100] ="Garside M R"
allNames[101] ="Gibson P"
allNames[102] ="Glaze J"
allNames[103] ="Goldshaw S"
allNames[104] ="Goodchild P"
allNames[105] ="Gray D"
allNames[106] ="Greensmith R"
allNames[107] ="Griffin B"
allNames[108] ="Grundy B"
allNames[109] ="Gultig W"
allNames[110] ="Gunning G"
allNames[111] ="Haddock P"
allNames[112] ="Haddow B"
allNames[113] ="Hagan J"
allNames[114] ="Hall M"
allNames[115] ="Halliday S"
allNames[116] ="Hampshire D M"
allNames[117] ="Hannett B"
allNames[118] ="Hardy G"
allNames[119] ="Hari Krishana"
allNames[120] ="Hari Rao Krish"
allNames[121] ="Harpham S"
allNames[122] ="Harrison S."
allNames[123] ="Harvey TD"
allNames[124] ="Hebburn Stores"
allNames[125] ="Henry Colin"
allNames[126] ="Hensby C"
allNames[127] ="Herbert O"
allNames[128] ="Herrity R"
allNames[129] ="Hewling K"
allNames[130] ="Hill D"
allNames[131] ="Hillman B"
allNames[132] ="Hilyer J"
allNames[133] ="Holdsworth T"
allNames[134] ="Hopkins B"
allNames[135] ="Hughes A"
allNames[136] ="Hughes P"
allNames[137] ="Isaacs S"
allNames[138] ="Jackson M"
allNames[139] ="James R"
allNames[140] ="Jamieson T"
allNames[141] ="Jarnie D"
allNames[142] ="Jones C"
allNames[143] ="Jones G"
allNames[144] ="Jones M."
allNames[145] ="Jones S"
allNames[146] ="Joyce T"
allNames[147] ="Kamaladoss B"
allNames[148] ="Keigan K"
allNames[149] ="Kemp N"
allNames[150] ="Kesdby"
allNames[151] ="Key M"
allNames[152] ="Kidd M"
allNames[153] ="King B"
allNames[154] ="Kirkley V J"
allNames[155] ="Kirkup S"
allNames[156] ="Kit 23"
allNames[157] ="Kit 24"
allNames[158] ="Kitchen"
allNames[159] ="Klofta E"
allNames[160] ="Klyn M"
allNames[161] ="Knowles J"
allNames[162] ="Laffey L"
allNames[163] ="Laing D"
allNames[164] ="Lamont T"
allNames[165] ="Laws J"
allNames[166] ="Lear S"
allNames[167] ="Leeds Stores"
allNames[168] ="Lenney D"
allNames[169] ="Leyland I"
allNames[170] ="Lindsay N"
allNames[171] ="Livingstone I"
allNames[172] ="Major M"
allNames[173] ="Manufacturer"
allNames[174] ="Marchant M"
allNames[175] ="Marjoram P"
allNames[176] ="Marshall C"
allNames[177] ="Marshall S C"
allNames[178] ="Marsland J"
allNames[179] ="Martin B"
allNames[180] ="Maskell K"
allNames[181] ="Mason J"
allNames[182] ="Mason P"
allNames[183] ="Mc Lean R."
allNames[184] ="McCabe S"
allNames[185] ="McCollum C J"
allNames[186] ="McDonald D"
allNames[187] ="McGeagh D"
allNames[188] ="McGeough D"
allNames[189] ="McGourley E"
allNames[190] ="McIntyre W"
allNames[191] ="McKenzie C"
allNames[192] ="McKenzie M"
allNames[193] ="McMahon C"
allNames[194] ="McMahon W"
allNames[195] ="McMenamin D"
allNames[196] ="McPhearson K"
allNames[197] ="McQuire B"
allNames[198] ="Meakin P"
allNames[199] ="Miller R"
allNames[200] ="Mitchell T.D"

//allNames = new Array("Adam","Albert","Andrea","Bill","Barb","Betty","Chris","Carl&quot

function loadSelect(letter){
sList = document.getElementById("mySelect&quot

//clear select first
for (x=1; x<sList.options.length; x++){
sList.options[x] = null
}
//now load list
var listCount = 0
for(x=0; x<allNames.length; x++){
if(allNames[x].substr(0,1) == letter){
sList.options[listCount] = new Option(allNames[x], allNames[x])
listCount ++
}
}
}

var alphabet="ABCDEFGHIJKLMNOPQRSTUVWXYZ";
for(var i=0;i<26;i++){
document.writeln(" <a href=\"javascript:loadSelect('"+alphabet.charAt(i)+"')\">"+alphabet.charAt(i)+"</a> "+(i!=25?'|':''));
}

</script>
<body onLoad="loadSelect('A')">
<form name="myForm">
<select multiple size=7 name="mySelect" id="mySelect"><option></select>
</form>
<br>
</body>

Many Thanks
Hotlips

mwolf00 · Jul 9, 2003

hmmm - seems to like it better when you go backwards...

function loadSelect(letter){
sList = document.getElementById("mySelect&quot

sLength = sList.options.length
//clear select first
for (x=sLength-1; x>0; x--){
sList.options[x] = null
}
//now load list
var listCount = 0
for(x=0; x<allNames.length; x++){
if(allNames[x].substr(0,1) == letter){
sList.options[listCount] = new Option(allNames[x], allNames[x])
listCount ++
}
}
}

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

mwolf00 · Jul 9, 2003

oopps - forgot a bit (the "=" sign)....

for (x=sLength-1; x>=0; x--){

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

HOTLIPS · Jul 10, 2003

Excellent... thanks very much.....can I ask for your help again.....as u can tell I'm knew to javascript....but what I'd like to do now is...
from the list of names I would like to select with the option of say.... maybe only one name or maybe several names... or even all names and built up a criteria string and use this string as the basis of a selection criteria string for a report from a database............. in otherwords.... I select ALL somwhere, or click through the list for 1 name..... or click several names... one after the other ... not in any particular order.... then when selection is complete... submit it in the form of a string back to my database for processing
I would be obliged for you help
Thanks again
Hotlips

mwolf00 · Jul 10, 2003

Are you using ASP to handle the form? If so then your code in your form handler page would look similar to this...

<%
'remember that the selected options will be sent as a comma separated list'
allSelected = split(request("mySelect&quot

,",&quot

sql = "SELECT * FROM myTable WHERE uName in ("
for x = 0 to uBound(allSelected)
sql = sql & "'" & allSelected(x) & "',"
next
'peel off last comma and add closing parenthesis'
sql = left(sql, len(sql)-1) & &quot

"

set rs = cn.execute(sql)

%>

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

adam0101 · Jul 18, 2003

mwolf00,
The script might run a little faster if you use

sList.length=1

instead of

for (x=sLength-1; x>0; x--){
sList.options[x] = null
}

Adam
while(woman.width>woman.height && wallet.value>0){beer++;vision.blur()};

mwolf00 · Jul 21, 2003

Thanks adam, I didn't know that you could remove list items so easily...

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

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!

Help !! Populate Drop down list

HOTLIPS

Technical User

mwolf00

Programmer

adam0101

Programmer

HOTLIPS

Technical User

HOTLIPS

Technical User

mwolf00

Programmer

HOTLIPS

Technical User

HOTLIPS

Technical User

mwolf00

Programmer

mwolf00

Programmer

HOTLIPS

Technical User

mwolf00

Programmer

adam0101

Programmer

mwolf00

Programmer

Similar threads

Part and Inventory Search

Sponsor