Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Form Auto-Population

Posted on 2004-10-15
9
Medium Priority
?
396 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 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
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

 
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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

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

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
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…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses
Course of the Month15 days, 14 hours left to enroll

580 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