cfselect get more data on same screen

mmaddox · Jan 30, 2004

I want to select a name from a select option, and have related information show up in other boxes based on the name selected, on the same screen. I can do a second query on a second page to the get the data, but is there a way to get it on the first screen.
This code works to populate the boxes with static data when a name is selected, but is there a way to get the site and phone data related to the selected name from the query to populate the boxes?

<CFQUERY NAME="GETDATA" DATASOURCE="contacts">
SELECT lastname, (lastname+', '+firstname) AS NAME, site, phone
from hlphone2
Order by Lastname
</CFQUERY>

<script type="text/javascript">
function boxes(){
document.myform.boxsite.value = "site";
document.myform.boxphone.value = "phone";
}
</script>

<cfForm action="fil2.cfm" method="post" name = "myform" >

<cfinput type="text" name="boxsite"><br>
<cfinput type="text" name="boxphone"><br>

<cfselect name="options" onChange="boxes()">
<cfoutput query="getdata">
<option value="#getdata.NAME#">#Getdata.NAME#</option>
</cfoutput>
</cfselect>
</cfform>

Thanx for any help

philhege · Jan 30, 2004

Check the Macromedia Developers' Exchange for the custom tag CF_TwoSelectsRelated (or CF_ThreeSelectsRelated if you need that functionality).

HTH,

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....

philhege · Jan 30, 2004

Um, whoops. I missed your point. While the custom tag populates another select box, you want textboxes populated.

There's some code in the MM forum that demonstrates this. It basically involves populating a Javascript array, and passing the primary key of the select to a function that searches the array and pops the fields with the values needed.

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....

philhege · Jan 30, 2004

This code, while not exactly what you need, should give you an idea of what to do. Replace the alert() statement with statements that change the value of the textboxes.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<cfset xyz="A1,A4,A9,B2,B4">
<cfset loopval=listlen(xyz)>
<html>
<head>
<title>Untitled</title>
<script language="JavaScript1.1">
ls = new Array();
<cfoutput>
<cfset counter=0>
<cfloop index="val" list="#xyz#">
<cfset counter=evaluate("counter+1&quot

>
ls[#counter#] = '#val#';

</cfloop>

function checkval() {
picked = document.blahzee.blah.selectedIndex;

thisval = document.blahzee.blah.options[picked].value;
for (x=1;x < #evaluate("loopval+1&quot

#;x++)
{if (thisval == ls[x]){alert('You got it; it is ' + thisval);
//the commands would be something like
//document.myform.boxsite.value = '#site#';
//document.myform.boxphone.value = '#phone#';
return true;
} }

}
</script>
</cfoutput>
</head>

<body>
<form name="blahzee" action="nothing" method="post">
<select name="blah" onchange="checkval();"><cfoutput><cfloop index="val" list="#xyz#"><option value="#val#">#val#
</cfloop></cfoutput><option value="A2">A2<option value="Q3">Q3</select>
</form>

</body>
</html>

Sorry for the confusion.

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....

ecobb · Jan 30, 2004

There is a tag in the Macromedia exchange that does exactly this. It's called CF_AutoPopulate. It can populate text boxes and/or hidden fields by whatever is chosen in a select box.

Hope This Helps!

Ecobb

"Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer." - Homer Simpson

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

cfselect get more data on same screen

mmaddox

IS-IT--Management

philhege

Programmer

philhege

Programmer

philhege

Programmer

ecobb

Programmer

Similar threads

Part and Inventory Search

Sponsor