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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326006 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4