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