> erik tom wrote: > > That looks great, but what I need is to post multiple values into 1 > field called foundOn. So once i select mi=ultiple values the foundOn > field will look for example like this 2,4,12 and so depends how many > items from drop down was selected > I was afraid that is what you where asking. You are asking for > trouble > with this highly de-normalized database design. It is very likely you > > will have trouble seaching and updating this value. > > But if you insist, you just need to insert your form value. form. > foundOn > is already the list you want to insert so just insert it. No reason > to > loop over this list and pull the individual values out if you are not > > going to use those individual values. > > I.E. > INSERT INTO dbo.MENU > values(...) > (...,...,#form.foundOn,'NULL') > > Again this is considered a bad practice. OK. Thanks for the reply I got it to work. and now I am facing another problem. I am trying to populate the select box based on the selection. so when i RUN THE QUERY it gives me the error. and my query is
select menuId,label,foundOn from menu where menuId IN convert(int(4),(select foundOn from menu where menuId=52)) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299465 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
