I want to establish a listbox (call it lb_one) where a user can select mutliple values. The values that are available for choosing depend on who the user is... i then have another list box (call it lb_two) that displays values according to the values that were selected in lb_one. These values are pulled from My question is this, (a) BASIC LIST BOX FUNCTIONALITY QUESTION how can i tell Coldfusion to read multiple values of the list box (lb_one) that have been selected. (b) LIST BOX MULTIPLE DEPENDENCY QUESTION how can i tell Coldfusion to pull the corresponding values (in db) into lb_two according to what was selected in lb_one >(b) would be simple if one value was selected , i already know how to do this. for example if only one value could be selected in lb_one and i assigned this value towards lb_two the SQL for the two list boxes would be ******** //lb_one SELECT PRODUCT FROM qry_screen_output WHERE ContactID = '#ContactId#' AND Team = '#Team#' Order by PRODUCT //lb_two SELECT COLOR FROM qry_screen_output WHERE ContactID = '#ContactID#' AND Team = '#Team#' AND PRODUCT = '#Product#' Order by COLOR ******* Notice that this line !!AND PRODUCT = '#Product#'!! is what connects lb_two to lb_one....once again all well and good for one selected item, how do i do multiple items?? (c) SUM OF SALES QUESTION This is the hardest part of my question. I want to output Sales info into a text box (tx_one) which will be determined by what was selected in the list boxes. ... For this part , assume you can select multiple values in lb_one as well as lb_two...whooo!!!!!!! So from lb_one and lb_two you may get a multiple selection of Products(PRODUCT) as well as a multiple selection of Product colors(COLORS)..The database is set up like so User ContactID Team PRODUCT COLOR SALES If the user had selected just one product and color it would have been easy to produce a text box showing the SALES for that combo.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. 4)tell me how you did it
windows 98 flash mx coldfusion mx