Show User State in DropDown List.......

FRANDAZZO · Dec 14, 2000

Hello,

I have a dropdown list(combo box) that has all the US states listed in it. The value that gets sent to the Database would be "NY" if the user selected "New York" from the list.

Here is what my dropdown list is for example:
<select name="States">
<option value="FL">Florida
<option value="NY">New York
</select>

Now we have an edit screen to edit a users info. This is the question--- How do I get the dropdown list to show the correct state the user lives in if I am only storing the value "NY" in the database.

I know of one way:
<option value = "NY" <% if myState="NY" then response.write "Selected">New York

but I would have to do that for each option tag. And the client does not want to store the option values in a database so I can build the dropdown list by doing a loop.

How am I going to do this.....

Thanks....

PepperPepsi · Dec 14, 2000

Hi FRANDAZZO,

you can use Javascript to set the default select object.
here the example,

<html>
<head>
<script>
<% mystate = "NY" %>
function setDefault()
{
for (i=0; i<document.formname.States.length; i++){
if (document.formname.States.options.value == '<%=mystate%>')
document.formname.States.options.selected = true;
}
}
</script>
</head>
<body onload="setDefault()">
<form method="POST" name="formname">
<p><select name="States">
<option value="CT">Connecticut</option>
<option value="FL">Florida></option>
<option value="NY">New York</option>
<option value="NJ">New Jersey</option>
</select>
</form>
</body>
</html>

The Javascript function SetDefault() will get call when the page is load, first it will search the value of all the option tags and find the one match (mystate). If match, javascript will assign that option to be selected.

hope this helps, Chiu Chan
cchan@gefmus.com

http://www.emagine-solutions.com

PepperPepsi · Dec 14, 2000

Hi FRANDAZZO,

here the function setDefalut() again

function setDefault()
{
for (i=0; i<document.formname.States.length; i++){
if (document.formname.States.options[i].value == '<%=mystate%>')
document.formname.States.options[i].selected = true;
}
}

hope this helps
Chiu Chan
cchan@gefmus.com

http://www.emagine-solutions.com

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!

Show User State in DropDown List.......

FRANDAZZO

Programmer

PepperPepsi

Programmer

PepperPepsi

Programmer

Similar threads

Part and Inventory Search

Sponsor