Secondary CFSelect w/Ajax

Perhaps not answering your question in regards to solving this code (and I apologise for that), but one remedy which I know works (I've written similar code to produce 'related select boxes') is to use jQuery.

Make a request to retrieve json formatted query results, which can populate the select box.

A second jQuery function can then be run onChange of the first select box, which will do the same thing, but will send off the id or whatever param you need to include in the second query.
Once the json results are back, jQuery will again populate the second select box with returned options/data.

A good starting point is here: http://www.coldfusionjedi.com/index.cfm/2008/12/16/Ask-a-Jedi-Mixing-ColdFusion-8-binding- with-jQuery

If you need any more help, let me know.

From one monkey to another.

Cheers

try this a work-around i have used before:

1) add this to the HEAD section of your page:
<cfajaxproxy bind="javascript:test({concern_id},'[#form.concern_id#]')">
<script type="text/javascript">
var imdone = false;
function test(x,val) {
if(!imdone) {
var dd = document.getElementById('concern_id');
valArr = ColdFusion.JSON.decode(val);
for(var i = 0; i < dd.length; i++){
for(var j = 0; j < valArr.length; j++){
if(dd.options .value == valArr[j]){
dd.options.selected = true;
}
}
}
imdone = true;
}
}
</script>

2) add bindonload="true" to your second cfselect

the only visible difference bettween my case and yours is that my cfc
function was returning QUERY and yours returns an array - try changing
the returntype in your cfc function if the above does not work...


Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

where are you adding this <cfif not isdefined... block and why???

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

oh, you must mean "TYPE_ID" and not "CONCENR_ID"?

looking at your original post, it shows that the value assigned to your
"type_id" cfselect is '16,Special Projects,36,QA', which is obviously
not numeric...

i suggest you stop messing with arrays and just return queries from your
cfc functions - that's all you need for the selects to work.

change your cfc functions to the following:


<cffunction name="call_types" access="remote" returntype="QUERY">
<cfset var data = querynew("concern_type, type_id", "varchar, integer")>
<cfset queryAddRow(data)>
<cfset querySetCell(data,"concern_type", "Special Projects")>
<cfset querySetCell(data, "type_id", 16)>
<cfset queryAddRow(data)>
<cfset querySetCell(data,"concern_type", "QA")>
<cfset querySetCell(data, "type_id", 36)>
<cfreturn data>
</cffunction>

<cffunction name="get_concerns" access="remote" returntype="QUERY">
<cfargument name="type_id" type="numeric" required="yes">
<cfset var data = "">
<cfquery name="data" datasource="#dsn#">
SELECT concern, concern_id
FROM pbr_concerns_masters
WHERE concern_type = <cfqueryparam cfsqltype="cf_sql_integer"
value="#arguments.type_id#">
ORDER BY concern
</cfquery>
<cfreturn data>
</cffunction>



Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/