Update multiple rows of informaiton

I'm needing help in understanding how to update x amount of rows of data with 3 check boxes for each row. I know how to do this with one set of check boxes but can't seem to figure out multiple boxes.

The check boxes have a value of 1 in them.

Thanks,

Brian
brihol44Asked:
Who is Participating?
 
PluckaConnect With a Mentor Commented:
Im not sure I understand the problem.

There are two ways to update multiple records.

1. Do Multiple Updates, ie loop over your logic and do an update for each iteration of loop
2. Update with a where, where all matching records would be updated in one hit. IE update table where category="y' all records with category Y would be updated.
0
 
brihol44Author Commented:
My code so far...
<cfparam name="form.pa" default="0">
<cfparam name="form.wa" default="0">
<cfparam name="form.na" default="0">
 
<cfquery name="get_advertisers" datasource="#dns#">
    SELECT * 
    FROM advertisers
    ORDER BY company_name
</cfquery>
 
<cfif isDefined("form.submit") AND form.submit EQ "submit">
    <cfloop from="1" to="#form.counter#" index="id">
            <cfquery name="update_advertisers" datasource="#dns#">
                UPDATE 
                    advertisers_ad_list
                SET  print_advertising = '#form.pa#',
                     web_advertising = '#form.wa#',
                     newsletter_advertising = '#form.na#'
                WHERE advertiser_id = '#form.advertiser_id#'
            </cfquery>
	</cfloop>
</cfif>
 
<form action="<cfoutput>#CGI.SCRIPT_NAME#</cfoutput>" method="post">
<table border="0" cellspacing="0" cellpadding="3">
  <tr>
    <td width="351">Company Name</td>
    <td width="61" nowrap="nowrap"><div align="center">Print Ad</div></td>
    <td width="88" nowrap="nowrap"><div align="center">Web Banner</div></td>
    <td width="81" nowrap="nowrap"><div align="center">Newsletter</div></td>
  </tr>
  <cfoutput query="get_advertisers">
      <tr bgcolor="###iif(currentrow MOD 2,DE('ffffff'),DE('efefef'))#">
        <td><input name="form.advertiser_id" type="field" value="#get_advertisers.advertiser_id#" />#get_advertisers.company_name#</td>
        <td><div align="center">
          <input name="pa" type="checkbox" value="1" />
        </div></td>
        <td><div align="center">
          <input name="wb" type="checkbox" value="1" />
        </div></td>
        <td><div align="center">
          <input name="nl" type="checkbox" value="1" />
        </div></td>
      </tr>
  </cfoutput>
</table>
<br />
<input name="submit" type="submit" value="submit"/>

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.