Aaron, Can you post how you where able to do the inserts? My situation is a little tricky. My insert consist adding the form values to two tables. The values productID and qty are added using using a function addProduct. The options are added using a second function called addOption. I must first get the primary key using transaction tag them pass that key to the second function along with all the form.options.
What I'm not clear on is: - if from the form page I send all the formfields to the first function (addProduct) how do i pass along all the form.option#count# values to the second function(addOptions)? My guess is I should create either a list or an array for all the form.options, pass it along the cart.cfc, get the primary key from the addProduct function, some how use the list/array to insert using the addOption fuction. Can anyone confirm this and point me to how do this? Form (fields): FORM.ProductID, FORM.Qty FORM.Option1 (option#count#) Tables: 1- cartTable - productLineID, productID, qty 2- optionIDTable - optionLineID, productLineIDoptionID Functions: cart.addProduct cart.addOption Thanks >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: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231490 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54