Hi Folks,
I have a question regarding binding dropdown list values. I have a set of names which i will be adding to a drop down list box. While the user selects an item from dropdown list, the person's email address should automatically come up in the text box next to it.
Name(Dropdown items) Email
1. John John.xxx@example.com
2. Adam Adam.yyy@example.com
3. Ramesh Ramesh@example.com
Please help/guide me so as how to achieve this requirement. Thanks in advance!!
Regards,
Chandhseke
5  3199 
If you have something like - <select id="email">
-
<option value="John.xxx@example.com">John</option>
-
// …
-
</select>
you can simply use a function to write the values to the text box. - function passAddress()
-
{
-
document.getElementById("textboxid").value = this.value;
-
}
-
document.getElementById("email").addEventListener("change", passAddress, false);
-
// use cross-browser event handling for IE …
Thank you!!. Since we are using javascript function to populate the Email address to text box, is there any drawbacks like buffering issue. Since sometimes in my code all the drop down values will get vanished off during approval process(Same page will be sent to different people based on number of levels).
Please comment on this?
Regards,
Chandhseke
Any update on my above thread? Please advise.
Regards,
Chandhseke
I do not understand the problem …
Hi,
As per the above conversation we had couple of months before, i used the same techinique in order to develop a dynamic drop down list by binding the dropdown values. The initial requirement was if an end user selects an item from dropdown then its his/her email address should automatically pop-up in the text box. Please find the below code.
//JavaScript to popup email address in a text box based on item selected from a drop down list. -
function addit()
-
{
-
document.getElementById("Category_Email").value = document.getElementById("CatProcDir").value;
-
document.getElementById("HidCatProcDir").value = document.getElementById("CatProcDir").options[document.getElementById("CatProcDir").selectedIndex].text;
-
}
-
-
function addEmail()
-
{
-
document.getElementById("OG_Email").value = document.getElementById("OGC_Name").value;
-
document.getElementById("HidOG_Email").value = document.getElementById("OGC_Name").options[document.getElementById("OGC_Name").selectedIndex].text;
-
}
-
//Actual ASP/HTML code -
<%@ Language = VBScript %>
-
<% Response.Buffer = true %>
-
<html>
-
<head>
-
<title>Supplier Decision Summary</title>
-
</head>
-
<body bgcolor="#666666">
-
<form action="SQLInsert.asp" method="post" name="SDS_step_one" onsubmit="return validate()">
-
<tr>
-
<td colspan="2" style="height: 32px">Regional/Category Procurement Director </td>
-
<td colspan="3" style="width: 999px; height: 32px;">
-
<select name="CatProcDir" id="CatProcDir" style="width: 242px" onchange="addit()">
-
<option value="">Select</option>
-
<option value="Chris.Jacob@au.unisys.com">(APAC)Jacob, Chris </option>
-
<option value="Dave.McAdam@au.unisys.com">(APAC)McAdam, Dave</option>
-
<option value="tony.o'connor@gb.unisys.com">(EMEA)O’Connor, Tony </option>
-
<option value="Graham.Chalmers@gb.unisys.com">(Global)Chalmers, Graham</option>
-
<option value="Martin.Sturla@unisys.com">(LACR)Sturla, Martin</option>
-
<option value="Christopher.Bowe@unisys.com">(NA)Bowe, Chris</option>
-
<option value="Jay.McKeever@unisys.com">(NA)McKeever, Jay</option>
-
<option value="mark.pagliaro@unisys.com">(NA)Pagliaro, Mark</option>
-
</select>-->
-
<select name="CatProcDir" id="CatProcDir" style="width: 242px" onchange="addit()">
-
<option value="">Select</option>
-
<%
-
SQLCatProc = "Select * from SDS_ProcApprovers where Deleted = 'No' Order By Cat_Proc_Name ASC"
-
Set Rs1 = oConn.Execute(SQLCatProc)
-
Do Until Rs1.EOF
-
%>
-
<option value="<%=Rs1("Cat_Proc_Email")%>"><%=Rs1("Cat_Proc_Name")%></option>
-
<%
-
Rs1.MoveNext
-
loop
-
Rs1.close
-
%>
-
</select>
-
</td>
-
-
</td>
-
<td colspan style="height: 32px"><input type="text" name="Category_Email" style="width: 250px" />
-
<input type="hidden" name="HidCatProcDir" value="" />
-
</td>
-
</tr>
-
<tr>
-
<td colspan="2">OGC Contact</td>
-
<td colspan="3" style="width: 999px">
-
<select name="OGC_Name" onchange="return addEmail()" style="width: 240px">
-
<option value="">Select</option>
-
<%
-
SQLOGC = "select * from OGC_Contact Where Deleted = 'No' order by OGC_Contact ASC"
-
Set Rs1 = oConn.Execute(SQLOGC)
-
Do Until Rs1.EOF
-
%>
-
<option value="<%=Rs1("OGC_Email")%>"><%=Rs1("OGC_Contact")%></option>
-
<%
-
Rs1.MoveNext
-
loop
-
Rs1.close
-
%>
-
</select>
-
</td>
-
<td colspan="3" style="width: 1259px"><input type="text" name="OG_Email" id="OG_Email" style="width: 250px" maxlength="100"/>
-
<input type="hidden" name="HidOG_Email" value="" />
-
</td>
-
</tr>
-
<input id="Submit" style="width: 180px" type="submit" value="Submit" onclick="document.SDS_step_one.Submitform.value = 'Submitted'"/>
-
<input type="Submit" value="Save and Submit Later" name="Save" onclick="document.SDS_step_one.Submitform.value = 'Saved'"/>
-
</table>
-
</form>
-
</body>
-
</html>
-
//SQLnew.asp in formaction will insert the form values to DB table. -
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
-
<!--#include file="Connection.asp" -->
-
-
<%
-
Select Case Trim(Request.Form("Submitform"))
-
Case "Submitted"
-
SQLAdd = "Insert into SDS (Last_Update, Scope, Category, Sourcing_Methodology, OGC_name, Approval2alt, Category_MGR, Approval3alt, Proc_Director, Approval6alt )" & _
-
"Values ('" & Today & "','" & Scope & "','" & Category & "','" & Source_method & "','" & HidOG_Email & "','" & Com_Email & "','" & HidCom_Email & "','" & OG_Email & "','" & HidCatProcDir & "','" & Category_Email & "')"
-
-
oConn.Execute SQLAdd
-
This form carries these data to 9 approvers for approval, but sometimes data in the drop down list will get disappeared automatically(both in form/DB).
Please help if there is anything that needs to be corrected in my code. THis is a old application therefore old technology being used.
Regards,
Chandhseke
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Jonny Tango |
last post by:
Hello everyone.
Q. How do I create a dynamically-generated drop-down list for use in
an array.
I'm using PHP with a MySQL database (through phpMyAdmin)
My database table is called...
|
by: jonnytansey2 |
last post by:
Can anyone out there give me a pointer regarding creating a
dynamically-generated drop-down list connected to an array?
And is that question as clear as chocolate spread?
Here's what I've got....
|
by: Chris Geier |
last post by:
string strLdap = "LDAP://OU=Sales,DC=Company,DC=com"
DirectoryEntry objOU = new DirectoryEntry(strLdap);
DirectorySearcher objUserSearcher = new DirectorySearcher(objOU);
SearchResultCollection...
|
by: msnews.microsoft.com |
last post by:
I'd like to hear your thoughts on best methods for populating drop down list
controls. I have states and countries drop down lists that don't change
often, so naturally I "hard code" them in the...
|
by: Leszek Taratuta |
last post by:
Hello,
I have several drop-down lists on my ASP.NET page. I need to keep data
sources of these lists in Session State.
What would be the most effective method to serialize this kind of data...
|
by: Yoshitha |
last post by:
hi
I have 2 drop down lists in my application.1st list ontains itmes like
java,jsp,swings,vb.net etc.2nd list contains percentage i.e it conatains the
items like 50,60,70,80,90,100.
i will...
|
by: mc |
last post by:
I've got three controls on a page
a Drop Down List, a List Box and a Button
I've added 3 items to the Drop Down List
I have added some code in the Button onClick Event Handler, as below...
|
by: Yi Chen |
last post by:
We have a drop down list on a PHP page, with several product names, and
when people click one item, we will refresh the same page with the
product name as parameter, and in turn we want to include...
|
by: mrtr33 |
last post by:
I have a class table where I want to access the names of courses and the description of each course. The names of the courses go in a drop down list. Based on the user selection, the description...
|
by: DaveRook |
last post by:
Hi
I am using C# and Access databse for a web site.
I have a drop down list which I need to populate dynamically according to results in a database.
Example
There will be 1 drop down list...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
