Update multiple rows/records at the same time

Hi,
is there a way to update all rows/records at the same time (one click) rather having indidual update button in each row? (see sample image attach).  User can update in any record (except ID column).

thanks,
pl
sample.gif
LVL 8
pdd1lanAsked:
Who is Participating?
 
Gurpreet Singh RandhawaConnect With a Mentor Web DeveloperCommented:
0
 
karl-henrikConnect With a Mentor Commented:

Yes you can and I think this blogpost will help you out quite nicely (better then me trying to explain).
http://www.coldfusionjedi.com/index.cfm/2009/2/10/Ask-a-Jedi-Updating-multiple-records-at-once

Have a nice day.
//Karl.
0
 
pdd1lanAuthor Commented:

I know how to update multiple records for one specific column, but this case I have multiple records in multiple columns that needs updating at the same time.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
gdemariaConnect With a Mentor Commented:
So concept, but more fields...  the form would be something like this...

 <form method="post">
  <table>
  <cfoutput query="getUser">
      <tr>
         <td><input type="text" name="firstName#ctr#" value="#getUser.firstName#" /></td>
         <td><input type="text" name="lastName#ctr#" value="#getUser.lastName#" /></td>
         <td><input type="text" name="color#ctr#" value="#getUser.color#" /></td>
      </tr>
  </cfoutput>
  </table>
  <input type="submit" name="save" value="Save" />
</form>


In your action page, you would get form variables...

FORM.FirstName1
FORM.FirstName2
FORM.FirstName3
...

FORM.LastName1
FORM.LastName2
FORM.LastName3
... etc...

You would loop through them using this notation to access the value   #form['firstName' & kk]#    
where KK is the row number you're processing...

0
 
gdemariaCommented:
should have been..
Same concept, but more fields
0
 
pdd1lanAuthor Commented:
myselfrandhawa,  it might be what I am looking for.  I will test it on Monday. thanks for the link
0
 
gdemariaCommented:
pl, I think you should restate your question to be more clear.   The first two posts show how you can update multiple records with one save button, and myselfrandhawa is indicating how to do so but those records are a child record of a parent.

Can you tell us what you're after and in what way these posts don't answer your question?
0
 
pdd1lanAuthor Commented:
thank you all for helps.
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.