|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
Defaulting 2nd select related select
<tr>Paul Ihrig 09/04/09 02:05 P and the functionPaul Ihrig 09/04/09 02:06 P got itPaul Ihrig 09/04/09 03:24 P i can default the first select just fine.Paul Ihrig 09/04/09 02:10 P <tr> <td>Territory: (id:#attributes.territory_id#)</td> <td><cfselect enabled="Yes" name="FORMterritory_id" multiple="no" bind="cfc:selectbox_binds.cfc.region_territorybindfunctions.GetTerritory({FORMregion_info_id})" bindonload="true" /> </td> </tr> and the function <!--- Get the territory based on region ---> <cffunction name="GetTerritory" access="remote" returntype="array"> <cfargument name="region_info_id" default="" required="yes"> <cfset TerritoryList=arraynew(2)> <cfset TerritoryList[1][1] = ""> <cfset TerritoryList[1][2] = "-- Select a Territory --"> <cfquery name="qTerritory" datasource="#request.dsn#"> SELECT territory_id, region_info_id, territory_id AS Tidx FROM region_territory_lookup WHERE (region_territory_lookup.region_info_id = <cfqueryparam value="#arguments.region_info_id#" cfsqltype="cf_sql_varchar">) ORDER BY territory_id </cfquery> <cfset TerritoryItemcount = 1> <cfloop query="qTerritory"> <cfif Len(Trim(territory_id))> <cfset TerritoryItemcount = IncrementValue(TerritoryItemcount)> <cfset TerritoryList[TerritoryItemcount][1] = trim(territory_id)> <cfset TerritoryList[TerritoryItemcount][2] = trim(Tidx)> </cfif> </cfloop> <cfreturn TerritoryList> </cffunction> </cfcomponent> i can default the first select just fine. but the 2nd one is driving me nuts... http://63.144.103.199/selectbox_binds/region_territory.cfm the 2 slects part works just fine. as dowes defaulting the first cfselect <cfparam name="attributes.region_info_id" default="20"> <cfparam name="attributes.territory_id" default="13"> <!--- Initialize select boxes with values ---> <cfif (isDefined("attributes.region_info_id") AND #attributes.region_info_id# NEQ "")> <cfajaxproxy bind="javascript:selectregion({FORMregion_info_id},'#attributes.region_info_id#')"> </cfif> <!--- Initialize select boxes with values ---> <cfif (isDefined("attributes.territory_id") AND #attributes.territory_id# NEQ "")> <cfajaxproxy bind="javascript:selectterritory({FORMterritory_id},'#attributes.territory_id#')"> </cfif> <script> var selectregiondone = false; var selectterritorydone = false; function selectregion(x,val) { if(!selectregiondone) { var dd = document.getElementById('FORMregion_info_id'); for(var i = 0; i < dd.length; i++){ if(dd.options[i].value == val){ dd.selectedIndex = i; } } selectregiondone = true; } } function selectterritory(x,val) { if(!selectterritorydone) { var dd = document.getElementById('FORMterritory_id'); for(var i = 0; i < dd.length; i++){ if(dd.options[i].value == val){ dd.selectedIndex = i; } } selectterritorydone = true; } } </script>
|
May 24, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||