populate text box from combo-box

gwilym40 · Nov 27, 2002

Hi

I have a combo box as follows, where name is what shows and ID and email are hidden.

<p><font face="Arial" size="2">Select your Name <select name = "reqname">
<option value="" select>Name</option>

<%Do While Not rsname.EOF
Response.Write ("<OPTION value="& rsname("id&quot

&">" & rsname("email&quot

& rsname("name&quot

& "</OPTION>&quot

rsname.MoveNext
Loop
rsname.Close
set rsname= Nothing %>
</select>
</font>

after the update of this combo-box I'd like to populate a text-box, named reqemail with the email address, taken from the value of the rsname("email&quot

field from the combo-box

how can i do this please?

thanks in anticipation!!!
kim

palbano · Nov 27, 2002

>> after the update of this combo-box

You mean when the user selects one in the browser?

-pete

gwilym40 · Nov 27, 2002

yeah when a user selects a name in the browser

sandyind · Dec 2, 2002

I hope this will solve your problem

<head>
<script language="javascript" >
//Used to pass the value selected from the combo box to the same page
function funcgo()
{
x=document.txtbox.reqname.value
top.location="testcmb.asp?txt=" + x
}
</script>
</head>

<body>
<p><form name="txtbox" action="testcmb.asp?txt=<%=request.Form("reqname&quot

%>" method=post>
<%Do While Not rsname.EOF
if request.QueryString("txt&quot

=rsname("id&quot

then%>
<input type=text name="text1" value="<%=rsname("email&quot

%>" ID="Text1">
<%end if
rsname.movenext
loop
rsname.movefirst%>

<font face="Arial" size="2">Select your Name <select name = "reqname" onchange="funcgo()">
<option value="" >Name</option>
<%Do While Not rsname.EOF
if request.QueryString("txt&quot

=rsname("id&quot

then
Response.Write ("<OPTION value="& rsname("id&quot

&" selected>" & rsname("email&quot

&" > "& rsname("name&quot

& "</OPTION>&quot

else
Response.Write ("<OPTION value="& rsname("id&quot

&" >" & rsname("email&quot

&" > "& rsname("name&quot

& "</OPTION>&quot

end if
rsname.MoveNext
Loop
rsname.Close
set rsname= Nothing %>
</select>
</font>
</form>

</body>

Tarwn · Dec 2, 2002

Hmm, why not just place a delimiter between the email and name in the option, than pull out the first part of the text and place it in the hidden field?

in your javascript section(pretend frmYourForm is your form name):

Code:

function setEmail(){
   var selElem = frmYourForm.reqname;
   var tOptText = selElem.options[selElem.selectedIndex].text;
   tOptText = tOptText.substring(0,tOptText.IndexOf(&quot; &quot;)-1;
   frmYourForm.hdnEmail.value = tOptText;
}

in your select section:

Code:

<select name=&quot;reqname&quot; onClick=&quot;setEmail();&quot;>
<option value=&quot;&quot; select>Name</option>
<%Do While Not rsname.EOF
Response.Write (&quot;<OPTION value='&quot;& rsname(&quot;id&quot;) &&quot;'>&quot; & rsname(&quot;email&quot;) & &quot; &quot; & rsname(&quot;name&quot;) & &quot;</OPTION>&quot;)        
rsname.MoveNext
Loop
rsname.Close
set rsname= Nothing %>
<input type=&quot;hidden&quot; name=&quot;hdnEmail&quot;>
</select>
</font>

Basically I added a space between your email and name in the option and then, since the email shouldn't have a space in it, I pulled out everything up to ther space and placed it in the hidden field. This was written on the fly so it may have be a little rough, but the logic should be sound.

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---

http://www.tuxedo.org/~esr/faqs/smart-questions.html

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!

populate text box from combo-box

gwilym40

Programmer

palbano

Programmer

gwilym40

Programmer

sandyind

Programmer

Tarwn

Programmer

Similar threads

Part and Inventory Search

Sponsor