Oh, that's what you were trying to do. I suppose my email completely missed the mark then! :o)
No worries. I'm glad someone was able to help you. :o) Cheers, Chris Bruce Sorge wrote: > Thank you Josh, that was it. > > Bruce > > On 12/19/06, Josh Nathanson <[EMAIL PROTECTED]> wrote: > >> Hi Bruce, >> >> I think you might want to reconsider looping over the field names. You >> are >> trying to insert multiple fields while looping over fields one at a time >> -- >> I don't think that will work. >> >> If you know how many groups of fields are coming from the form (the last >> number on the end of _ on your fields), you could do something like below. >> For example you have 4 groups of NAME, PHONE and EMAIL fields, >> form.numgroups would be 4. There is probably a loop in your form that is >> generating the dynamic fields so you would pass that value as a hidden >> form >> variable. Below is not tested but I think you'll have more luck if you go >> down that road. >> >> <cfloop from="1" to="#form.numgroups#" index="i"> >> <cfset namefield = "NAME_" & i> >> <cfset phonefield = "PHONE_" & i> >> <cfset emailfield = "EMAIL_" & i> >> >> <cfquery datasource="#Application.dsource#"> >> INSERT INTO tblElection_Committee >> (Proc_ID, Name, Phone, Email) >> VALUES (#Session.Procedure_ID# >> <cfif len(StructFind(form, namefield))> >> ,#StructFind(form, namefield)# >> <cfelse> >> , '' >> <cfif> >> >> <cfif len(StructFind(form, phonefield))> >> ,#StructFind(form, phonefield)# >> <cfelse> >> , '' >> </cfif> >> >> <cfif len(StructFind(form, emailfield))> >> ,#StructFind (form,emailfield)# >> <cfelse> >> , '' >> </cfif>) >> </cfquery> >> </cfloop> >> >> >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264505 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
