I thought I had tried that, but I had tried it with 
value="<cfoutput>#shooter_id[currentRow]#</cfoutput>".

The <cfoutput>'s around the value was causing the
values to append because I was already using <cfoutput query = ...>
Nested <cfoutput>'s... bad boy.

But now I realize that I've got to figure out how to specify
the names of the checkboxes which are checked for the insert query.
The problem is with specifying which dynamic formfield has been checked.
Perhaps I can run a cfloop on the "get_unregistered.recordcount" value
and run a check to see if form.shooter_#index# is in the fieldnames...

<cfloop from="1" to="#get_unregistered.recordcount#" index="i">

     <cfif isdefined("form.shooter_#i#")> (or something like that...)

          <cfquery name="register_shooters" datasource="#application.dsn#">
        
               insert into registrations
                      ( shooter_id, tournament_id )
               values ( <cfqueryparam cfsqltype="cf_sql_integer" 
value="#form.shooter_#">,
                        <cfqueryparam cfsqltype="cf_sql_integer" 
value="#session.tournament_id#"> )
                                 
          </cfquery>

     </cfif>

</cfloop>

Problems with that?  Suggestions?

Rick





> -----Original Message-----
> From: Matt Quackenbush [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 25, 2008 8:57 PM
> To: CF-Talk
> Subject: Re: What am I missing???
> 
>  <input name="shooter_#currentrow#" type="checkbox"
> value="#shooter_id[currentRow]#">
> 
> 
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:311541
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to