Unfortunately that isn't working for me either Dave. Maybe the problem is in the valueList part? I have two different tables I could query, one simply lists each tip_id with one associated mcd, so that I could have the same tip_id appear in multiple rows IF there are multiple mcds. The other table is a view that lists the tip_id then all of the mcds strung together in one cell, so that I only have one row per tip. I've tried each of them with the same results, but I honestly don't know which one I *should* be querying. Is one better than the other? Any advice on how to create that valueList?
Thanks, Christina >Christina, > >The solution might be that in your 'selected' attribute on the <cfselect> >tag, you are specifying "#qdMcd.mcd#" which would only indicate ONE value. >If you want all the MCD's listed from the qdMCD query, then you need to put >selected="#valueList(qdMcd.mcd)#" > >Dave > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-newbie/message.cfm/messageid:4046 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
