Thanks to Matt and Philip for helping out with this. I have the form page displaying correctly now. HOWEVER, (and there always is one with me) I thought of one of those user-error things. What if the user tells the page she wants to add 10 records, but only fills in eight of them? If I use the initial loop value (which I am calling NumForms) there will be empty records added. Any ideas? Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 4/4/2003 5:09:07 AM >>> Similar to Matt's solution, but name your Form fields with a numeric extension <input type="text" name="Name_#i#" value="#HTMLeditFormat(Form["Name_#i#"])#"> Then when you're inserting, just use the form["Name_#i#"] Remember to pass the number of entries along with the form, otherwise you won't know how many to loop over I'd use the underscore to separate the field name from the number HTH > -----Original Message----- > From: Candace Cottrell [mailto:[EMAIL PROTECTED] > Sent: Friday, April 04, 2003 12:56 AM > To: CF-Talk > Subject: Multiple forms, looping and inserting > > > Ok, so I have an idea, but I'm not sure how to carry it through. > > I have a basic insert record page. However, I want the person > to be able to add 5, 10, or 15 records at a time, depending > on the value they select from a drop-down. Meaning, depending > on how many they want to add, there will be that many forms, > and one submit button to add all the records. > > I'm thinking I need a loop somewhere, but not sure where. > > Any help is greatly appreciated! > > Here's what I have so far: > > addSite.cfm: > > > <form name="MultiForm" > action="addSite.cfm?MultiForm=TRUE&NumForms=#NumForms#"> > <select name="NumForms"> > <option value="5">5</option> > <option value="10" selected>10</option> > <option value="15">15</option> > </select> > <input name="" type="submit" value="Show"> > </form> > > <cfif MultiForm IS True> > <form action="addSite2.cfm" method="post" name="addSite"> > <cfloop from="0" to="URL.NumForms" index="i"> > <table width="100%" border="0" cellspacing="2" cellpadding="5"> > <tr> > <td width="24%" class="copyTeal"><div > align="right">Author Name: </div></td> > <td width="76%"><input name="Website_author" > type="text" id="Website_author"></td> > </tr> > <tr> > <td class="copyTeal"><div align="right">Website link:</div></td> > <td><p> > <input name="Website_Link" type="text" > id="Website_Link" size="45"> > </p> > <p><span class="tealHeader">Please include the > http:// and remember to > verify the link's accuracy.</span></p></td> > </tr> > </table> > <p class="tealHeader"> > <input type="submit" value="Continue"> > </p></cfloop> > </form> > > <cfelse> > <form action="addSite2.cfm" method="post" name="addSite"> > <table width="100%" border="0" cellspacing="2" cellpadding="5"> > <tr> > <td width="24%" class="copyTeal"><div > align="right">Author Name: </div></td> > <td width="76%"><input name="Website_author" > type="text" id="Website_author"></td> > </tr> > <tr> > <td class="copyTeal"><div align="right">Website link:</div></td> > <td><p> > <input name="Website_Link" type="text" > id="Website_Link" size="45"> > </p> > <p><span class="tealHeader">Please include the http:// and remember to verify the link's accuracy.</span></p></td> </tr> </table> <p class="tealHeader"> <input type="submit" value="Continue"> </p> </form> </cfif> The problem is that the page is trying to run the loop regardless of if the upper form has been submitted or not. And then it says that my "to" value is invalid because it isn't a simple data type. Thanks for taking the time to read my rambling :) Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
