asked on

Pass currently selected form field value to CFWINDOW for insert into query.

I am using CFWINDOW to add some records on the fly. I have have 2 select boxes in a form and 1 select is a child of the other. When I add a record to the child select using CFWINDOW, I need to pass the parent selects current value to the cfwindow so I can insert it with the new child record. My problem is, I don't know how to pass that value to the cfwindow. Here is what I have for code.

I need to get the value of SALE_BUYER_ID and pass it to my insert query somehow.

<!---             Index.cfm             ---->
 
<cfinclude template="addWindow.cfm">
 
<cfform name="sale">
 
<cfselect name="sale_buyer_id" id="sale_buyer_id" size="1" bind="javascript:getSaleBuyers()" bindonload="true" display="sale_buyer_Name" value="sale_buyer_id" selected="#sale.sale_buyer_id#" />
 
<br />
 
<select name="sale_buyer_yard_id" id="sale_buyer_yard_id">
</select>
 
<a href="javascript:addSaleBuyerYard();">[add new]</a>
 
</cfform>
 
 
 
<!---             addWindow.cfm             ---->
 
<cfajaximport tags="CFWINDOW, CFFORM">
<cfajaxproxy cfc="addWindow" jsclassname="salebuyeryardProxy">
 
<!--- js functions --->
<script type="text/javascript">
var openWindow = function(name,title,url,options){
 ColdFusion.Window.create(name, title, '', options);
 ColdFusion.navigate(url, name);
};
 
<!--- Functions specific to adding a new SALE BUYER YARD --->
var addSaleBuyerYard = function(){ //opens add_Salebuyeryard.cfm page in a cfwindow for adding new auction data
 ColdFusion.Window.create('sale_buyer_yard_id_window', 'Add Sub-Yard', 'add_SaleBuyerYard.cfm', {center:true,height:300,width:380,closable:true,dragable:true,resizable:true,modal:true,initshow:true});
};
 
var getSaleBuyerYards = function(){ //uses ajax proxy to populate cfselect
 var p = new salebuyeryardProxy();
 var populate = p.getSaleBuyerYards4cfselect();
 return populate;
};
 
var onHideAddSaleBuyerYard = function(name){ //refreshes the cfselect
 ColdFusion.Bind.assignValue('sale_buyer_yard_id', 'value', getSaleBuyerYards());
};
 
 
<!--- END UNIQUE FUNCTIONS --->
var onAddNewSuccess = function(name, fcn){ //my generic function to handle newly added data
 ColdFusion.Window.onHide(name, fcn);
 ColdFusion.Window.hide(name);
 var el_id = name.substr(0,name.indexOf('_window'));
 setNewSelectedOption(el_id);
};
var setNewSelectedOption = function(id){
 var el = document.getElementById(id);
 var arrV = new Array();
 for (var i=0; i<el.options.length; i++){
  arrV[i]=el.options[i].value;
  if (el.options[i].value == Math.max.apply(Math,arrV)){
   el.options[i].selected=true;
  }
 }
};
 
</script>
 
 
 
 
 
<!---             My INSERT query in the add_SaleBuyerYard.cfm page            ---->
 
<cfquery name="insert" datasource="#request.dsn#">
INSERT INTO sale_buyer_yard
(sale_buyer_id, sale_buyer_yard, sale_buyer_yard_directions)
VALUES
(#VALUE OF SALE_BUYER_ID#, '#TRIM(UCASE(FORM.sale_buyer_yard))#', '#TRIM(UCASE(FORM.sale_buyer_yard_directions))#')
</cfquery>

Open in new window

ASKER CERTIFIED SOLUTION

SidFishes

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

Oh perfect. Thanks!!!

MFredin

ASKER

Sorry, I think I closed this question too soon. Is there a way I could use javascript to find the current value of a select box and add it to the URL when I launch my addSaleBuyerYard(); function? I'm not very JS savvy, so example code is needed please.

MFredin

ASKER

Since it will be grabbing a value, potentially after load since the use will most likely be changing the select box, can this still be done?

SidFishes

something like this should work

var addSaleBuyerYard = function(){

var param = document.getElementById('sale_buyer_id').value;
ColdFusion.Window.create('sale_buyer_yard_id_window', 'Add Sub-Yard', 'add_SaleBuyerYard.cfm?sale_buyer_id' + param, {center:true,height:300,width:380,closable:true,dragable:true,resizable:true,modal:true,initshow:true});
};

MFredin

ASKER

It worked! One last question... I can create a new one so you can get the points if you want?

I want to do the same type of thing with a cfc...

Here is what my cfc code looks like with the javascript added... obviously I am missing some things.. Can you fill in the blanks so it would work?

Thanks for the help!

<!--- Sale Buyer Yards CFC to fill the cfselect query --->
<cffunction name="getSaleBuyerYards4cfselect" access="remote" returntype="query" output="false">
<cfset var qGetSaleBuyerYards="">
 
<!--- Get the current value of the parent select box to use in the query --->
var param = document.getElementById('sale_buyer_id').value;
 
<cfquery name="qGetSaleBuyerYards" datasource="#request.dsn#">
SELECT sale_buyer_yard_id, sale_buyer_yard
FROM sale_buyer_yard
WHERE sale_buyer_id = param
ORDER BY sale_buyer_yard
</cfquery>
 
<cfreturn qGetSaleBuyerYards />
</cffunction>

Open in new window

MFredin

ASKER

SidFishes,

I created this similar question earlier... just add a comment and I will award the points since you answered it here.