Thanks Will, After getting the multiple values inserted I was going to work on getting the multiple values updated as well. I have a CommunityMX tutorial (http://www.communitymx.com/abstract.cfm?cid=E68A448AE1116988) in my possession about updating multiple records that I was going to use to implement my update CFC. However, I was needing something that would tell me how to get the values from the same form field just as with the insert.
I will definitely take a look at your example! I am kind of surprised that this seems to be more complicated then I thought. Perhaps because linking tables is so common in db design that I thought these kinds of inserts and updates would be basic. -Aaron On 2/4/06, Will Tomlinson <[EMAIL PROTECTED]> wrote: > I don't know if this will help, but I'm doin the same kinda thing with an > update form. > > The trick is just hardcoding a flag letting you know it's an option. Then > loop over the fieldnames and grab them. I setup an example here a while back: > > http://wtomlinson.com/blog/client/?mode=entry&entry=8133A377-3048-2B55-92EB5E5652FF066C > > Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231386 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
