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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:299421 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
