Updating text field / On Change

ScottMusich · Jan 9, 2004

I use MX and i have a form with a list (first Name). When I selec the list I want the other text field to put in the corresponding last name from the database in the field on the form...

I know I need to use an OnChange function but not sure exactly how to grab the second field from the database based on the users selection.

Thanks

Scott Musich
Online Editor

GUJUm0deL · Jan 9, 2004

ScottMusich, what server-side scripting are you using?? Coldfusion, ASP, CGI??

If its coldfusion, then something like: <input type="textfield" name="somename" value="#firstname#">

This will have the value read from the dB, just make sure the onChange is called.

The following example will load a name into the textfield depending on what the drop-down selection was:



<html>
<head>
<title>Passes Value From the Drop-Down Choice To the Textfield</title>
<meta name="author" content="Ketan V. Mehta">

<script language="javascript">
function displ() {
//if the forms element is 0 (the first one) then return false; do nothing.
if(document.myFORM.valu.options[0].value == true) {
return false
}
else {
//otherwise, place the appropriate <option value> in the texfield from the drop-down menu.
document.myFORM.textfield.value=document.myFORM.valu.options[document.myFORM.valu.selectedIndex].value;
}
return true;
}
</script>
</head>

<body bgcolor="#FFFFFF" text="#000000">
<table border="0" cellspacing="0" cellpadding="0" width="75%">
<tr>
<td width="100%">
<form name="myFORM" onClick="return displ();">
<select name="valu" size="1">
<option value>Choose One</option>
<option value="MT001">MT0001 | Copper Cable Shield 1</option>
<option value="MT002">MT0002 | Copper Cable Shield 2</option>
<option value="MT003">MT0003 | Copper Cable Shield 3</option>
</select>
<input type="text" name="textfield" readonly>
</form>
</td>
</tr>
</table>
<p><font color="#D3342C" size="2" face="Verdana">Select a value for the drop down
and watch as the appropriate <option value> is placed into the checkbox.</font></p>
<p><font color="#D3342C" size="2" face="Verdana">For instance if <strong><option
value="Some Text Here">Click Me</option></strong> is selected,
then the value of the option (Some Text Here) is placed in the textfield.</font></p>
</body>
</html>

[sub]Reality continues to ruin my life...[sub]

ScottMusich · Jan 14, 2004

Sorry - I am using ASP. I will look at your suggestion closer and try it out

thanks

Scott Musich
Online Editor

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!

Updating text field / On Change

ScottMusich

Programmer

GUJUm0deL

Programmer

ScottMusich

Programmer

Similar threads

Part and Inventory Search

Sponsor