Multiple Update of Records Part 2

Part 2 Multiple Update of Records

This tutorial will show you how to update multiple records on the same page as the multiple delete action. Must read Part 1 to understand how things are setup.

Part 1 Multiple Delete of Records

This tutorial will show you how to perform a multiple delete of records in one operation.

Note:
if the recordset in the working example is empty, you will have to wait untill i have filled it again with records.

Source:
4guysfromrolla, changed for use with Macromedia Ultradev/MX.

Multiple Update of Records (Part 2)

This tutorial will show to update multiple records on the same page as the delete multiple record.

First of all it would be wise to read the part 1 of this turorial, because we are going to use that example to expand it with this feature.

Step 1: creating the recordset and the form (altered).

We will call the page Default.asp and the form would look something like this:

This page has some changes made to the column NAME. Instead of just a column display we will make this a text field and make it dynamic by drag&drop of the appropiate database field. Also a additional button has been added for updating the links (more about this later).

We need to a few things to make this work:

  • the ID that associates to the column NAME ( to know which Name field belongs to which ID if we update it)
  • a counter variable to keep track of the number of records to be updated
  • use this counter variable to make the ID and NAME field unique( so that we know which ones belongs to each other when we loop through the counter based on these unique names)

Go to Step 2 >>

 

 

Marcellino Bommezijn

Marcellino BommezijnMarcellino Bommezijn is one of the managers at dmxzone.com. He is a contributor on the tutorials section.

Owner of Senzes Media (http://www.activecontent.nl) which provides professional services and web applications for mid-sized companies.

ActiveContent CMS is the ASP.NET Content Management solution that is used for building professional and rich-featured websites.

See All Postings From Marcellino Bommezijn >>

Comments

Example link has changed !

September 28, 2001 by Marcellino Bommezijn

Please note that the link has been changed into:

http://www.ultradev-asp.net/udzone_tutorials/multiple/delete/Default2.asp

The complete code??

December 9, 2001 by Helle M

Will it be possible to download the asp page at some time?? I'm not so hot a code writer, and it's a BIG help to see a hole page with everything to understand it all---
Helle:-)

Update 2 Fields

December 17, 2001 by Evan Scolaro

Is it possible to Update 2 Fields instead of updating 1 (sCatName) like this example. Thanks for your help

How to ...

September 27, 2002 by haj Hou
How to update 2 or more Fields? Can you tell me how to modify the code of your part 2 article ? THX!!
See all 41 Comments

You must me logged in to write a comment.