Bingo.... I have multiple form fields in the insert <input name="name_1" type="text" /> <input name="name_2" type="text" /> <input name="name_3" type="text" />
<input name="company_1" type="text" /> <input name="company_2" type="text" /> <input name="company_3" type="text" /> I think this should work Thanks Ade.. Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 12:59 pm To: CF-Talk Subject: RE: Looping over submitted form fields Importance: Low Is there? If you have for example: <input name="name_1" type="text" /> <input name="name_2" type="text" /> <input name="name_3" type="text" /> Then on the action page: <cfloop from="1" to="3" index="i"> query INSERT .... #FORM["name_" & i]# /query <cfloop> Is that what you mean? Ade -----Original Message----- From: SStewart [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 17:56 To: CF-Talk Subject: Looping over submitted form fields There's a method for doing multiple record inserts from a form, and I've completely forgotten how to do it.... Help Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206552 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