Forums

This topic is locked

multidelete of records

Posted 11 Apr 2002 08:59:29
1
has voted
11 Apr 2002 08:59:29 Serge Chabert posted:
Hello

Does anyone knows where to find a good tutorial about multidelete of records. let me explain :
i would like to have all the users on my site to appear on a page in order to check the boxes of the one i want to delete.

Thanks

<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Replies

Replied 11 Apr 2002 13:28:56
11 Apr 2002 13:28:56 jason parker replied:
Have you tried typing 'multiple delete' into the search box on the home page of UDzone.com or even searching this forum for previous posts?

HTH - Jaysun
Replied 11 Apr 2002 13:31:55
11 Apr 2002 13:31:55 David Behan replied:
There is a lovely extension that does this and it has great tutorial backup to get you on your way. What you need is all located at:

udzone.com/showDetail.asp?TypeId=3&NewsId=2048

Regards...

_________________________
David Behan - www.bmor.com
Replied 11 Apr 2002 13:52:33
11 Apr 2002 13:52:33 Serge Chabert replied:
I have downloaded the extension a few weeks ago and i tried to understand from the tutorial, but i could not. it is very confusing, that is why i was wondering if there was a tutorial more "user's friendly".

[

quote]
There is a lovely extension that does this and it has great tutorial backup to get you on your way. What you need is all located at:

udzone.com/showDetail.asp?TypeId=3&NewsId=2048

Regards...

_________________________
David Behan - www.bmor.com
Replied 11 Apr 2002 14:11:32
11 Apr 2002 14:11:32 David Behan replied:
Here is a quick tutorial...

Create a repeat region displaying your recordset details. At the start of the line insert a check box. Associate the value of the checkbox with the id of the record so that when it is checked the checked value is 1 or 10 or 45 or etc. Give the checkbox the name "deleteid".

This whole repeat region table has to be within a form obviously. Once above is down, insert your submit button below and outside the repeat region.

Previewing should give you a list of records filtered from the database with a ckeckbox, name and any other field you like. At the bottom of the list should now be a submit button.

Now open a new page. Call this page recordset_del.asp or something like that. Delete all the tags on the page so that it is blank. Using your server behaviours select PM and then delete multiple records.

In the input boxes enter the following:

String Parameter: deleteid

Connection Name: select your connection from drop down

Database Table Name: select your table from drop down

Database Field Name: select your id field from drop down

Redirect after delete action: something like delete_ok.asp

Redirect if no selection made: something like delete_fail.asp


Save this page and close it.

Create a page delete_ok.asp and delete_fail.asp with something in the text like "delete successful" and "no selection made please try again" respectively.

Open your listing page. Set your form to post to recordset_del.asp.

Now... test test test


~~~~~~~~~~~~~~~~~~~~~~~~~~

Give me a shout if you need any more help with this

_________________________
David Behan - www.bmor.com

Reply to this topic