Christina, You should set up the DB to have a tip_id containing a single mcd if that is the case. Then you only have to get the MCD list from one table. If there is only a single mcd, the list will be short, but you don't have to go somewhere else to get it (plus then you can just add to that list as need be).
I presume your value list is returning a comma separated list? Rob On Tue, Oct 14, 2008 at 4:30 PM, Christina K <[EMAIL PROTECTED]> wrote: > 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:4047 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
