<cfloop index="x" from="1" to="#noOfFieldsYouhave#">
<cfif isdefined("form.boothtype" & x) and isdefined("form.boothqty" & x) and
evaluate("form.boothqty" & x) GTE 1>
<cfquery...>
insert whatever
</cfquery>
</cfif>You can post to a page with the above code and do you inserts.. I hope i got your question clear. Joe ----- Original Message ----- From: "Terry Hilton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 12:33 PM Subject: Dynamic Form Fields > As part of an application that I am building, I have some dynamically named > form fields that need to be added to a SQL 2000 db. > > ex. > boothtype1 [checkbox], boothqty1 [text field] > boothtype2 [checkbox], boothqty2 [text field] > boothtype3 [checkbox], boothqty3 [text field] > > For each boothtype that is checked, I need to create a record in the table > with the exhibitorid, boothtype and boothqty. Can anyone suggest a good way > to do this? > > BTW - I am also using the cf_reuseform tag with this form. > > Thanks, > > Terry Hilton > Web Developer > Two and One, Interactive > > > ==^================================================================ This email was sent to: [email protected] EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9 Or send an email to: [EMAIL PROTECTED] T O P I C A -- Register now to manage your mail! http://www.topica.com/partner/tag02/register ==^================================================================
