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.
| User Level: | Any |
|---|---|
| Product: | Dreamweaver MX, UltraDev 4 |
| Database: | SQL Server 2000 |
| Server Model: | ASP VBScript |
| Browser: | All |
|
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:
|
Marcellino Bommezijn
Marcellino 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.
User Reviews
Total of 40 reviewsRE:not direct via js
Written by cumap cumap on August 16, 2007Nevermind, I realized forms is incorrect and I changed it to the correct form name and the function is working now.Thank you for the great batch update code.
not redirect via js
Written by cumap cumap on August 16, 2007I don't get it but the javascript redirect function does not take me to the update.asp page. Any idea?
OK Sorted - Read below for solutions.
Written by Kevin Dandridge on August 3, 2006Ok I seriously had problems getting it sorted out and finally with perseverence, and tweak after tweak and some 20 hours later I got it. (sorry this submits on 'Enter' Keypress) I can't even begin to mention the teething problems so I thought I'd ...
OK Sorted - Read below for solutions.
Written by Kevin Dandridge on August 3, 2006Ok I seriously had problems getting it sorted out and finally with perseverence I got it.
Fantastis Tutorial and download
Written by peter Jarvis on January 24, 2005I am a designer, not a programmer. I had two order tables in my database that were linked in the access databse and managed to amend the delete page so that it deleted out of both tables, this is brilliant, so simple to ammend and tailor. Job well ...
RE: RE: RE: How to update checkbox?
Written by Jennifer Glinski on January 10, 2005I have the same question about updating multiple records using a checkbox. How do you incorporate 'checkbox|null,1,0| into this example. I couldn't find any posted solutions and this is the only place I have found someone having the same problem ...
Fixed it
Written by Scott Iwamoto on May 27, 2004Sorry I just realized that it is counting the records. doh! The problem was that I had the hiddenfield Count in the repeating region thus the type mismatch error. Awesome tutorial .... Thx =)
ID fieldtype = varchar
Written by Scott Iwamoto on May 27, 2004How can I get this to work if my ID field is varchar? Thanks.
