Solved

Update multiple rows of informaiton

Posted on 2008-06-12
2
269 Views
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.

Thanks,

Brian
0
Comment
Question by:brihol44
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Author Comment

by:brihol44
ID: 21774357
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
 
LVL 18

Accepted Solution

by:
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.
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
The viewer will learn how to count occurrences of each item in an array.
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…

623 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