Solved

Update multiple rows of informaiton

Posted on 2008-06-12
2
251 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
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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

810 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