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:
HelloDoes 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
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
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
[
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
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