The problem turned out to be nested cfoutput's...
And the solution for the insert query for the dynamic checkboxes
that I've got working is: (The page submits back to itself, hence
the session variables...)
<cfloop from="1" to="#session.get_unregistered_recordcount#" index="i">
<cfif isdefined("form.shooter_#i#")>
<cfset shooter = "form.shooter_#i#">
<cfquery name="register_shooters" datasource="#application.dsn#">
insert into registrations
( shooter_id, tournament_id )
values ( <cfqueryparam cfsqltype="cf_sql_integer"
value="#evaluate(shooter)#">,
<cfqueryparam cfsqltype="cf_sql_integer"
value="#session.tournament_id#"> )
</cfquery>
</cfif>
</cfloop>
This is working, but suggestions for improvements are always welcome!
Thanks!
Rick
> -----Original Message-----
> From: Azadi Saryev [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 25, 2008 9:20 PM
> To: CF-Talk
> Subject: Re: What am I missing???
>
> Matt's suggestion should work, but it really shouldn;t be necessary...
>
> do you have your cfoutput inside a cfloop or the other way around?
> what if you properly scope both recordcount and shooter_id with a query
> name?
>
> Azadi Saryev
> Sabai-dee.com
> http://www.sabai-dee.com/
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:311546
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
