why not name the checkboxes the same, which will result in a comma-delimited
list. then you only have to check for one checkbox.
<cfoutput q
<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>
On Mon, Aug 25, 2008 at 6:37 PM, Rick Faircloth <[EMAIL PROTECTED]>wrote:
> 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:311543
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
