The example I posted will add items to a select list and insert into the database.
Russ -----Original Message----- From: Jillian Koskie [mailto:[EMAIL PROTECTED] Sent: 12 August 2005 18:36 To: CF-Talk Subject: RE: Add additional rows Hmm... That would work (again, I'm not sure how). Has anybody done this and has a code example? I'd need to allow users to go back in and edit these records using a form as well. -----Original Message----- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 10:14 AM To: CF-Talk Subject: RE: Add additional rows How about one single field for the authors with a button that adds the value to a multi select. Then when you are adding the form values to the database, you just loop over the value of the multi select -----Original Message----- From: Jillian Koskie [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 10:39 AM To: CF-Talk Subject: RE: Add additional rows John, I don't think this will work... I would really like to just be able to add as many dropdown lists as required. -- Jillian -----Original Message----- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 8:26 AM To: CF-Talk Subject: RE: Add additional rows You could do a pop-up window that handles adding a row to the database and then uses javascript to update a multiple select list with the new option that was added. It's a bit cumbersome, but if you don't know the limits of how many you want to add at a time, that's probably easiest. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -----Original Message----- From: Jillian Koskie [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 10:19 AM To: CF-Talk Subject: Add additional rows Good morning, I have a bit of an unusual problem, that I am hoping has a very easy solution. I have a form that adds content to a database --but I need to be able to allow my user to dynamically add rows (for additional authors) to the form... because he never knows how many authors there will be. So I need a way to add the lines without reloading the page/losing the form data (or do I have to just populate the form with 'form variables'?). I also need a way to loop through the results and insert them into the database. Has somebody done this that they can either show me / help me through the logic on this one? -- Jillian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214808 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
