Update multiple rows of informaiton

Posted on 2008-06-12
Last Modified: 2013-11-19
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.


Question by:brihol44

Author Comment

ID: 21774357
My code so far...
<cfparam name="" default="0">

<cfparam name="form.wa" default="0">

<cfparam name="" default="0">

<cfquery name="get_advertisers" datasource="#dns#">

    SELECT * 

    FROM advertisers

    ORDER BY company_name


<cfif isDefined("form.submit") AND form.submit EQ "submit">

    <cfloop from="1" to="#form.counter#" index="id">

            <cfquery name="update_advertisers" datasource="#dns#">



                SET  print_advertising = '',

                     web_advertising = '#form.wa#',

                     newsletter_advertising = ''

                WHERE advertiser_id = '#form.advertiser_id#'




<form action="<cfoutput>#CGI.SCRIPT_NAME#</cfoutput>" method="post">

<table border="0" cellspacing="0" cellpadding="3">


    <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>


  <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" />


        <td><div align="center">

          <input name="wb" type="checkbox" value="1" />


        <td><div align="center">

          <input name="nl" type="checkbox" value="1" />





<br />

<input name="submit" type="submit" value="submit"/>

Open in new window

LVL 18

Accepted Solution

Plucka earned 500 total points
ID: 21775038
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.

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Browsers only know CSS so your awesome SASS code needs to be translated into normal CSS. Here I'll try to explain what you should aim for in order to take full advantage of SASS.
"In order to have an organized way for empathy mapping, we rely on a psychological model and trying to model it in a simple way, so we will split the board to three section for each persona and a scenario and try to see what those personas would Do,…
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now