I got a little problem here. I am using cfform format flash and I cfgrid which
list menu items. Also have dynamic set of drop downs (access Levels). What i am
trying to is by selecting menu item preload the appropriate drop down.
Since it a flash form i need to use Action Script. Also in the list of menu
items i only want to list the menu item once , but i get as many listings as
diff menu accesses menu have.
Here is my query to pull menu items
<cfquery name="mainmenu" datasource="cfelsunrise" dbtype="ODBC">
select
a.label,a.menuID,a.link,b.foundOn,m.accessType,m.AccessValue
from menu a
inner join menufoundon b on a.menuId=b.menUId
inner join menuAccesstable m on
m.menuID=a.menuID
order by a.label
</cfquery>
And here is my action script
<cfsavecontent variable="getComboBoxValue">
<cfloop query="menuQuery">
//Set a temp variable to hold
the current comboBox value
var temp;
//Loop through all the comboBox
values
for(var i = 1; i <
access#accessType#.length; i++){
if
(access#accessType#.getItemAt([i]).accessValue
==myGrid.selectedItem.accessValue) {
//set the comboBox to the
current index
access#accessType#.selectedIndex=i;
//set temp to the value of the
comboBox
//if temp equals the selected
clientID then stop looping through the comboBox
}
}
</cfloop>
</cfsavecontent>
Please help prepopulate the drop downs. This is very URGENT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316655
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
