Jose, I placed all three queries into one function and wrapped transaction tags around the queries. Here is the guts of my function (except for the arguments):
<!--- Insert record into product table ---> <cfquery name="rsInsertProduct" datasource="#application.dsn#"> INSERT INTO products( prodTitle, prodModel, prodPic, prodSDesc, prodLDesc, prodHits, prodActive) VALUES( '#arguments.prodTitle#', '#arguments.prodModel#', '#arguments.prodPic#', '#arguments.prodSDesc#', '#arguments.prodLDesc#', '#arguments.prodHits#', #arguments.prodActive#) </cfquery> <!--- Get prodID from the previously inserted record ---> <cfquery name="rsNewProduct" datasource="#application.dsn#"> SELECT MAX(prodID) as new_prodID FROM products WHERE prodTitle = '#arguments.prodTitle#' </cfquery> <!--- loop through the list of formats and insert a record for each into the proddetails linking table ---> <cfloop collection="" list="#formats#" index="i" delimiters=","> <cfquery name="rsProdDetails" datasource="#application.dsn#"> INSERT INTO prodDetails( prod_ID, prodformat_ID, proddetailDesc, proddetailPrice, proddetailSpecial, proddetailSpecialPrice, proddetailDateAdded) VALUES( #rsNewProduct.new_prodID#, #format_ID#, '#arguments.detailDesc#', '#arguments.detailPrice#', #arguments.detailSpecial#, '#arguments.detailSpecialPrice#', '#arguments.detailDateAdded#') </cfquery> </cfloop> The last query is incomplete because it does not insert multiple records. I am still working on this part, but before I finalized it I decided to work on the form that would be passing the arguments the values for this insert. -Aaron On 2/6/06, j s <[EMAIL PROTECTED]> wrote: > 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:231495 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