I'll probably go back to your approach, Charlie. I was working on that...looping the list from the shooter formfield...but figured something was wrong because my values were being combined in the HTML output. I was certain that should work, but the problem I didn't notice at the time was the nested cfoutput's, so I thought I was just wrong about the formfields with the same name become a list automatically.
Thanks, Charlie and everyone! :o) Rick > -----Original Message----- > From: Charlie Griefer [mailto:[EMAIL PROTECTED] > Sent: Monday, August 25, 2008 9:50 PM > To: CF-Talk > Subject: Re: What am I missing??? > > accidentally hit 'send' :\ > > that should have read: > > form page: > > <cfoutput query="get_unregistered"> > <input type="checkbox" name="shooter" > value="#get_unregistered.shooter_id#" /> > </cfoutput> > > action page: > > <cfif structKeyExists(form, 'shooter')> > <cfloop list="#form.shooter#" index="idx"> > <cfquery name="register_shooters" datasource="#application.dsn#"> > INSERT INTO Registrations ( > shooter_id > , tournament_id > ) VALUES ( > <cfqueryparam value="#idx#" cfsqltype="cf_sql_integer" > /> > , <cfqueryparam value="#session.tournament_id#" > cfsqltype="cf_sql_integer" /> > ) > </cfquery> > </cfloop> > </cfif> > > -- > A byte walks into a bar and orders a pint. Bartender asks him "What's > wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought > you looked a bit off." > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311547 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4