An unchecked checkbox doesn't exist in the subsequent form scope. Move
your CFIF up above your CFSET's:
<cfloop index="pmt" from = "1" to = "#form.numrows#">
<cfif isDefined("form.paid_#pmt#") and Trim(pd) eq "Confirmed">
<cfset pd=form['paid_' & pmt]>
<cfset rid=form['regid_' & pmt]>
<cfquery datasource="#dsn#" name="upreg">
UPDATE dbo.ShowRegistration SET Payment='Confirmed' WHERE
(RegistrationID=#rid#)
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322075
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
