asked on

CFSelect: Getting 'bind' to work with selected values

Hey Guys,

I've got a couple cfselects i'm binding. Everything is working great, except there really isn't any out of the box solution to preselect the values if you are, for example, using the form to edit records. I found a few articles on some workarounds and this one seemed to work for others... http://www.stevenksavage.com/content/500/3.en.cfm

My problem is I'm still a CF n00b and I can't figure out how to implement this fix. So I'm hoping someone can point me in the right direction with this.

Here is what I have for code... How could I implement the fix to the preselect values?

<!---------------------------Here are my cfselects -------------------------------->
<cfselect name="sale_buyer_id" id="sale_buyer_id" size="1" bind="cfc:lots.addWindow.getSaleBuyers4cfselect()" bindonload="true" display="sale_buyer_Name" value="sale_buyer_id" />
 
<cfselect name="sale_buyer_yard_id" id="sale_buyer_yard_id" bind="cfc:lots.addWindow.getSaleBuyerYards4cfselect({sale_buyer_id})" bindonload="false" display="sale_buyer_yard" value="sale_buyer_yard_id" />
 
 
<!---------------------------Here are my functions --------------------------------->
<cfcomponent displayname="populate">
 
<!--- Sale Buyers CFC to fill the cfselect query --->
<cffunction name="getSaleBuyers4cfselect" access="remote" returntype="query" output="false">
<cfset var qGetSaleBuyers="">
 
<cfquery name="qGetSaleBuyers" datasource="#request.dsn#">
SELECT sale_buyer_id, sale_buyer_name
FROM sale_buyer
ORDER BY sale_buyer_name
</cfquery>
 
<cfreturn qGetSaleBuyers />
</cffunction>
 
<!--- Sale Buyer Yards CFC to fill the cfselect query --->
<cffunction name="getSaleBuyerYards4cfselect" access="remote" returntype="query" output="false">
<cfargument name="sbid" required="no" default="0">
<cfset var qGetSaleBuyerYards="">
 
<cfquery name="qGetSaleBuyerYards" datasource="#request.dsn#">
SELECT sale_buyer_yard_id, sale_buyer_yard
FROM sale_buyer_yard
<cfif arguments.sbid gt 0>
WHERE sale_buyer_id = <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.sbid#">
</cfif>
ORDER BY sale_buyer_yard
</cfquery>
 
<cfreturn qGetSaleBuyerYards />
 
</cffunction>
 
</cfcomponent>

Open in new window

erikTsomik

you need to include selected options

MFredin

ASKER

erikTsomik,

Not clear on what you mean by selected options. You mean the values I want to be selected?

azadisaryev

"selected" attribute does NOT work in cfselects with bindings.
here's a very good solution using a bit of js and <cfajaxproxy>:
http://www.coldfusionjedi.com/index.cfm/2007/8/7/Selecting-default-items-using-ColdFusion-8s-AJAX-Controls

steven's solution (the link you posted) looks interesting, but i have not yet been able to make it work...

Azadi

MFredin

ASKER

Thanks Azadi,

The solution you linked to works for the first select box, but I can't seem to get it working on the second select box.

<!--- Pre Select the Sale_Buyer_Id form element --->
<cfajaxproxy bind="javascript:test({sale_buyer_id},2)">
<script>
var imdone = false;
function test(x,val) {
if(!imdone) {
var dd = document.getElementById('sale_buyer_id');
for(var i = 0; i < dd.length; i++){
if(dd.options[i].value == val){
dd.selectedIndex = i;
 
}
}
imdone = true;
}
}
</script>
 
<!--- Pre Select the Sale_Buyer_Yard_Id form element --->
<cfajaxproxy bind="javascript:test2({sale_buyer_yard_id},3)">
<script>
var imdone = false;
function test2(x,val) {
if(!imdone) {
var dd = document.getElementById('sale_buyer_yard_id');
for(var i = 0; i < dd.length; i++){
if(dd.options[i].value == val){
dd.selectedIndex = i;
 
}
}
imdone = true;
}
}
</script>

Open in new window

ASKER CERTIFIED SOLUTION

azadisaryev

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MFredin

ASKER

Ah yes, makes sense! Thanks!!