AsFusion

What if I'm pulling my data from a query not a array? How would the variable="actionPopulate" read?

Thank you this site has helped me tremendously. What I would like to know is how I can populate a third cfselect. I tend to get the third select list but the list doesnt change when I select the a different index in the second select.

Honestly I not sure how the code needs to be added to have a third select.

I have one more question please. I would like the lists for the selects have a blank option in the list first as the list is populated in the secound and third select. I have to generate information based on the selections. Currently I can not as eg: select a item in the first select that has other list attached to it for the secound and third selects. The other lists populate without a blank option field. I know its has to to with the code in the cfsavecontent tag.

I would really appreciate your help as what code would look like

Kind regards

Wayne

Hi LM,

I would like to help you. I can send you the code to help you with this. I need to know whether you are also using CFC's of you are just pulling the store proceedure straight into the .cfm page

HINT: You will need to have a seperate query for each select which can be done in a single store proceedure with seperate result sets.

You then will using the results of each result set from the store proceedure to populate the selects.

Hope this helps :)

Wayne (South Africa)

Thanks for the code. I am new to CF7 actionscript, too. What if a state is preselected? In my code selectCity stays grayed out, even if the statefield is preselected coming into the page

I figured it out...Thanks.

Michael.

Got a bit of a workaround, or what may be the solution... What do you think?

<cfquery name="sample" datasource="#application.dsn.oiws#">
SELECT *, employee +' - '+ EMPLID AS Myname
FROM sooeAuditPMP
ORDER BY Employee
</cfquery>

<cfselect queryposition="below" label="Recipient" name="eeid" query="sample" value="EMPLID" display="Myname" width="200" >
<option>Please select an employee</option>
</cfselect>

I am having trouble replacing the hard-coded queries with 2 queries in my CFC.

I can get the State select to populate without any problem, but I can't figure out how to determine which StateID is the selected one (to be used in my query that populates the city select).

Thanks!

Patrick G.

Hi,

I have a question about having multiple selects in the parent category and then having all the options displayed in the child cfselect. Even if you do allow multiple selects for the parent cfselects, it only will display the last selected parent's child option. Is there a way you can have multiple child option displayed if there are multiple parent options selected. For example if I wanted to look at Toyotas and Nissans, and then select the Camry and Maxima to compare. Just wanted to know if it was possible and how it could be done. Multiple="yes" allows you to select it, but doesn't populate it. Thank you for your time and mainly for this great resource you have provided.

Chris

Hey Wayne,

Did you ever get a solution for your problem related to your comment:

"I have one more question please. I would like the lists for the selects have a blank option in the list first as the list is populated in the secound and third select. I have to generate information based on the selections. Currently I can not as eg: select a item in the first select that has other list attached to it for the secound and third selects. The other lists populate without a blank option field. I know its has to to with the code in the cfsavecontent tag."

Could you post-it there for me?

Thanks!

Raphael.

I am not sure if someone has addressed this issue yet. If so please let me know.

I am having problem with my version of related select boxes in a cfform. I have 3 select boxes. The first box controls what is displayed in the other 2 boxes and that's it. I used flash remoting with the form and it works exactly how I want it except for one thing. When I change the first select box, the information displayed in the other 2 are correct, but the values always come up as undefined. When I test the information returned after the remoting call, it will give me the correct text displayed, but the current value of the selected index is undefined. Is there a way to correct this? And each select box has it's own cfc method that populates its information.

Laura:

I have been trying to get this code to work for awhile. The problem I am having is that I need to pull the informaiton to make the querynew() from an existing query. Can you please tell me how to do this or give me a starting push?

Thank you

Hi I'm trying to work your code using queries rather than code the options for the drop down. Its not quite working and i think this is related to a problem in the action script, although being a novice I'm not sure what to do. Does anyone have any advice? Here is my code:

<cfquery name="QREGION" datasource="OSM">
SELECT * FROM Region
</cfquery>

<cfquery name="Qmain" datasource="OSM">
SELECT * FROM MAINTABLE
</cfquery>

<cfquery name="test" datasource="OSM">
SELECT * FROM test
</cfquery>




<cfscript>
region = queryNew("regionid,regionname",'varchar,varchar');
for (x = 1; x LTE qregion.RecordCount; x=x+1) {
   queryAddRow(region);
      querySetCell(region,'regionid','#qregion.regionid[x]#');
      querySetCell(region,'regionname','#qregion.regionname[x]#');
      

}
</cfscript>

<cfscript>
district = queryNew("regionid,district",'varchar,varchar');
for (x = 1; x LTE test.RecordCount; x=x+1) {
   queryAddRow(district);
      querySetCell(district,'regionid','#test.regionid[x]#');
      querySetCell(district,'district','#test.district[x]#');
      }
</cfscript>







<cfsavecontent variable="actionPopulate">
if(_global.arrCities == undefined) _global.arrCities = selectCity.dataProvider.slice(0);
   
   var arrCities:Array = _global.arrCities;
   selectCity.removeAll();
   
for(var i = 0; i < arrCities.length; i++)
   {
   var item = arrCities[i].data.split('|');
      if(item[1] == selectregion.value )
      {
         selectCity.addItem(arrCities[i].label,item[0]);
      }
   }
   selectCity.enabled = (selectCity.length >0) ? true:false;
</cfsavecontent>







<html>
<head>
<title>OSM</title>


<meta http-equiv="Content-Type" content="text/html;">
<!-- Fireworks MX Dreamweaver MX target. Created Fri Jun 20 14:42:26 GMT+0100 (GMT Daylight Time) 2003-->
<body bgcolor="#ffffff">
<div align="center">
<cfform action="/osm_menu2.cfm" format="flash" height="650" width="650" method="post">
<cfformgroup type="tabnavigator">
      <cfformgroup type="page" label="Reporting" height="300">
      
      
      <cfformgroup type="horizontal" label="Region:">

      </cfformgroup>
      
      <cfformgroup type="horizontal" label="Region:" >
      <cfselect queryposition="below"
name="selectregion" query="region" value="regionid"
display="regionid" width="200"
onChange="#actionPopulate#">
<option>Please select a parent category</option>
</cfselect>
   </cfformgroup>
      <cfformgroup type="horizontal" label="District:">
      <cfselect queryposition="below"
name="selectCity" width="200" >
<cfoutput query="district"><option value="#district#">#district#</option></cfoutput>
</cfselect>
      </cfformgroup>
      <cfinput type="submit" name="submit1" value="submit">
      </cfformgroup>

         
</cfformgroup>
</div>
</cfform>
</body>

I would lay odds that the script isn't what is slow - it will be found with your graphics card/main desktop. It's a lot of data it'll shove around. A person with a "snappy" desktop will see the 1000 recodrs with much less display lag that you will. Always been a problem with big "lists, tables, etc.". Not CF/Flash related directly, but with the computer's ability to process such a long list. Anyway to logically break it down some?

Sorry neglect above question.It looks like i should be able to get most of the info here:

Binding a grid to a grid
http://www.asfusion.com/blog/entry/quick-grid-bindings

Thanks

Hi Laura,

I have combobox that populate by dataprovider.

var search_Planname:mx.controls.ComboBox = search_Planname;
responseHandler.GetPlanName_Result = function( results: Object ):Void {
//when results are back, populate the cfselect
search_Planname.labelField = "Planname";
search_Planname.dataProvider = results;
}

I want to have "Select All" option as the first option in the combobox. I tried using QueryPosition but it doesnt work.

Thanks.

Here's the code I use to display cfselect which will be populate from the event above. It dont show "Select All" as I want.

<cfselect name="search_Planname" query="qGetPlan" queryPosition="below"
display="PlanName" value="PlanNum" width="450" disabled="false" label="Plan Name:" >
<option value=""> Select All</option>
</cfselect>

It's been solved.

May be you guys can help me out with this, I'm using the above code for the two selects. This works just fine, but I'm trying to make the second select populate some text fields by doing an onChange event but for some reason the form will not display. here is the CFC code and the cfsavesontent code.

<cffunction name="contactRet" access="remote" returntype="query">
<cfargument name="groupid" type="numeric" default="" required="yes">
<cfargument name="cont_name" type="string" default="" required="yes">
<cfquery name="retCont" datasource="mysqlcf_otgadmin">
SELECT contactid,groupid,cont_name,cont_address,cont_city,cont_state,cont_zipcode,cont_phone,cont_email
FROM contacts
WHERE groupid = '#groupid#' AND cont_name = '#cont_name#'
</cfquery>
<cfreturn retCont>
</cffunction>

<cfsavecontent variable="ContactsReturn">
if ((groups.value != '') && (contacts.value != '0')){
//create connection, replacing the gateway url with yours
var connection:mx.remoting.Connection = mx.remoting.NetServices.createGatewayConnection("http://<cfoutput>#cgi.HTTP_HOST#</cfoutput>/flashservices/gateway/";);
   
//declare service
var myService:mx.remoting.NetServiceProxy;
//put the controls in scope to avoid calling _root
   
    var groupid = groups.value;
    var cont_name = contacts.value;
   
    //make an object that will handle the response
var responseHandler = {};
   
    //function that receives the response
responseHandler.onResult = function( results: Object ):Void {
//when results are back, we show the text received
    //_root.groupid.text = results.getItemAt(0).groupid;
      _root.cont_name.text = results.getItemAt(0).cont_name;
      _root.cont_address.text = results.getItemAt(0).cont_address;
      _root.cont_city.text = results.getItemAt(0).cont_city;
      _root.cont_state.text = results.getItemAt(0).cont_state;
      _root.cont_zipcode.text = results.getItemAt(0).cont_zipcode;
      _root.cont_phone.text = results.getItemAt(0).cont_phone;
      _root.cont_email.text = results.getItemAt(0).cont_email;
      
mx.controls.Alert.show(Object(results));
}
    //function that receives any error that may have occurred during the call
responseHandler.onStatus = function( stat: Object ):Void {
//if there is any error, show an alert
alert("Error while calling cfc:" + stat.description);
}
    myService = connection.getService("otgadmin.cfc.contactsCom", responseHandler );
//make call, passing one parameter
myService.contactRet(groupid,cont_name);
      }
}
else {
mx.controls.Alert.show('Please Select a customer from the customer list or check the Add Contact box and enter the customer information!');
}
</cfsavecontent>