Solved

Form Auto-Population

Posted on 2004-10-15
9
348 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
  • 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
 
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
Free camera licenses with purchase of My Cloud NAS

Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

 
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
 
LVL 5

Expert Comment

by:kkhipple
ID: 12324199
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
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…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now