Dependent CFSELECTS using CF7’s Flashforms

by kai on 08/03/2005

While playing with the Flashforms in CF 7 yesterday I nearly went mad as it didn’t work easily to have two CFSELECT controls, both published by a particular db query, in which the first allows to select the parent category and the second one displaying a particular set of entries related to the selection of the first select control.

The problem is that CFSELECT doesn’t allow binding in the way other Flashforms controls do. With the help and support of Reto Aeberli who provided me with a basic code snippet I was able to get it running finally:

<cfquery name="a" datasource="flashformstest">
        SELECT *
        FROM test

<cfquery name="b" datasource="flashformstest">
        SELECT * 
        FROM test2

<cfsavecontent variable="astest">
var i; 
var b_id =',');
var b_label = myform.label.split(',');
var b_parentid = myform.parentid.split(',');

myselect2.enabled = true;

for (i=0; i<b_id.length;i++) 
        if (b_parentid[i]==myselect1.value) 

<cfform name="myform" format="flash" width="400">
        <cfselect queryposition="below" label="Parent category"
                  name="myselect1" query="a" value="ID" 
                  display="WERT" width="200" 
                <option>Please select a parent category</option>
        <cfselect disabled="true" label="Sub category" 
                  name="myselect2" width="200">
        <cfinput type="hidden" value="#valuelist(b.ID)#" 
                 name="id" width="1">
        <cfinput type="hidden" value="#valuelist(b.AID)#" 
                 name="parentid" width="1">
        <cfinput type="hidden" value="#valuelist(b.WERT)#" 
                 name="label" width="1">    

LM March 31, 2005 at 12:00 am

Great code.. i was trying to get it working because i need to develop something similar but unfortunately get error message: invalid parameter: b.ID. Any ideas? Any help is much appreciated!!

Bruce Trevarthen May 27, 2005 at 12:00 am

That works brilliantly!! Wicked!!!

kapitannwel April 28, 2008 at 12:00 am

great code! works perfectly. you guys rocks! i love you!

mario May 13, 2008 at 12:00 am

Works great! But, what I have to do in order to work with cfform in html format? My form is not in flash format. Thanks in advance.

Comments on this entry are closed.

Previous post:

Next post: