Solved

Form Auto-Population

Posted on 2004-10-15
9
382 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 50 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 50 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
Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

 
LVL 7

Accepted Solution

by:
black0ps earned 50 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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

690 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