[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Form Auto-Population

Posted on 2004-10-15
9
Medium Priority
?
391 Views
Last Modified: 2013-12-24
I have a form, that once the user chooses a name, I want it to automatically fill in information from the query onto the form.

<CFQUERY datasource="myds" name="employees" blockfactor="100">
      SELECT *
      FROM tbl_employees
      WHERE Active=1
      ORDER BY SortName asc      
</CFQUERY>

And the form just looks like this:

Name:  Drop Down box with names from the above employees query
Agt ID:  Blank Box (this is where I want the agt ID from the employees query to populate automatically when the user chooses a name from the above box.

Is there any way to do this?
0
Comment
Question by:Lee R Liddick Jr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +2
9 Comments
 
LVL 21

Expert Comment

by:pinaldave
ID: 12322586
This is how you populate the values of the checkbox.

Empolyee account :<input type="text" name="activated_accounts1" value="#employees.activated_accounts#">

I will post hte code for this automatically populated by selecting drop down soon.
Regards,
---Pinal
0
 
LVL 21

Assisted Solution

by:pinaldave
pinaldave earned 200 total points
ID: 12322603
Okey this is what you will have to do is use javascript or submit button .
I will use javascript that submits to itself when someone selects the drop down and form post to itself and
that will run another query of
<CFQUERY datasource="myds" name="employees" blockfactor="100">
     SELECT *
     FROM tbl_employees
     WHERE Active=1
 and account_id = #form.account_id#
     ORDER BY SortName asc    
</CFQUERY>

adn then post the result in
<input type="text" name="activated_accounts1" value="#employees.activated_accounts#">
0
 
LVL 5

Assisted Solution

by:umbrae
umbrae earned 200 total points
ID: 12322808
Put this in the HEAD section of your page:
<script language="javascript">
var agents = new Array();
<cfoutput query="employees">
agents[#employees.currentRow#] = "#employees.agtID#";
</cfoutput>
</script>

then in your body code:

<select name="employeenames" onChange="document.getElementById('empagtID').value = agents[this.selectedIndex.value];">
<cfoutput query="employees">
<option value="#employees.currentRow#">#employees.name#</option>
</cfoutput>
</select>

<input type="text" name="empagtID" id="empagtID">


This may work. Code is untested, but I think something like that will get you the results you're looking for.

-Umbrae
0
Plesk WordPress Toolkit

Plesk's WordPress Toolkit allows server administrators, resellers and customers to manage their WordPress instances, enabling a variety of development workflows for WordPress admins of all skill levels, from beginners to pros.

See why 2/3 of Plesk servers use it.

 
LVL 7

Accepted Solution

by:
black0ps earned 200 total points
ID: 12322868
<cfquery name="Employees">
</cfquery>
<form name="Emp">
<select name="Employee" onChange="document.Emp.ID.value = this.options[this.options.selectedIndex].value;">
<cfoutput query="Employees"><option value="#Employees.AgentID#">#Employees.Name#</option>
</cfoutput>
</select>
<input type="text" name="ID" value="">
</form>
0
 
LVL 5

Expert Comment

by:kkhipple
ID: 12324170
try this piece of code....  

<javascript>

function entsub() {

function ConfirmSSN(sSSN)
{
  document.all.WorkFrame.src = "confirmSSN.cfm?SSN=" + sSSN;
}


function enterinfo()
  {
  document.employees.SSN.value = retssn;
  ConfirmSSN(retssn)
  }
</script>
<body bgcolor="silver">
<!--- Begin Form --->
<table style="border-width: thin; border-color: black; border-style:
solid;">
<tr>
<td>
<table cellspacing="2" cellpadding="2" border="0">
<form name="employees" action="index.cfm" method="post">
<tr>
<td colspan="2" class="text"><font style="font-size:
8pt;"><strong>Search Employees By Social Security
Number</strong></font></td>
</tr>
<tr>
    <td class="text">SSN:</td>
    <td><input type="text" name="SSN" class="field" size="10"
onkeyup="entsub();" ondblclick="ConfirmSSN(this.value);"> <a href="#"
onclick="showModalDialog('namepopup.cfm',window,'dialogHeight:276px;dial
ogWidth:261px');" name="button" id="button"><img src="popup.gif"
border="0"></a></td>
</tr>
<!---Hide rest of form until --->
<tr>
    <td class="text">Last Name:</td>
    <td><input READONLY type="text"  name="last" size="15"
class="nonfield"></td>
</tr>
<tr>
    <td class="text">First Name:</td>
    <td><input READONLY type="text"  name="first" size="15"
class="nonfield"></td>
</tr>
<!--- end div --->
</form>
</table>
</td>
</tr>
</table>
<!--- end form--->
<!--- create Workframe --->
<iframe id="WorkFrame" name="WorkFrame" height="0" width="0"></iframe>
0
 

Author Comment

by:Lee R Liddick Jr
ID: 12328525
pindaldave, umbrae, and blackops...i've tried those suggestions and still can't get it to work.  The best I've gotten was the one from blackops, but it's giveing me a wrong value in the Agt ID box.  I will look at this again sometime soon, but going to just divide the points between you guys and try and figure it out later.  Thanks...
0
 
LVL 7

Expert Comment

by:black0ps
ID: 12329284
I think I can speak for umbrae and pindaldave, that it's not just about points. We want to help you get this deal working. Post the code that you are using and I'll give you some more advice on what to populate where.

-- Ian
0
 

Author Comment

by:Lee R Liddick Jr
ID: 12337889
Yes I know, just didn't want to keep this open until I got to it.  I just opened another question and it is posted at http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_21172334.html if you wanted to take a look at it.  Thanks guys...
0

Featured Post

Understanding Web Applications

Without even knowing it, most of us are using web applications on a daily basis. Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We often confuse these web applications tools for websites.  So, what is the difference?

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question