Delete multiple entries
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=3574
Printed Date: 29 March 2026 at 11:50pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Delete multiple entries
Posted By: pedalcars
Subject: Delete multiple entries
Date Posted: 16 June 2003 at 8:23am
|
I have an outputted table; I'd like to have a checkbox at the start of each row (that's not the problem!) and have a "delete" button that would delete any entries for which the respective checkbox was ticked, all at once (i.e., rather than having a "delete" button for each entry and having to delete one entry at a time).
Is this possible, and how? Thanks ------------- http://www.pedalcars.info/ - www.pedalcars.info The most fun on four wheels 
|
Replies:
Posted By: MorningZ
Date Posted: 16 June 2003 at 2:05pm
|
name the checkboxes the same, and set the value of each one as the Primary Key of the table and then on postback For each CheckedBox in Request.Form("CheckboxName") ------------- Contribute to the working anarchy we fondly call the Internet |
Posted By: ljamal
Date Posted: 16 June 2003 at 3:36pm
|
or you name the checkboxes the same and set the value ot the primary key and use this
if not Request("checkboxname")="" then strSQL = "delete from table where primarykey in ("&request("checkboxname")&")" end if ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: Gary
Date Posted: 17 June 2003 at 2:31am
|
I may be wrong here, but wouldn't that example only work if the data types are numerical? If the pk data type is text, then you would need to quote each value. If this is the case, then maybe populating an array with all the values would get around the problem. You'd have to loop through the array, deleting 1 row at a time. |
Posted By: ljamal
Date Posted: 17 June 2003 at 8:41am
|
If you pK is not numerical then you can surround it with single quotes in the checkbox value like this
<input type=checkbox name=name value="'value'"> and use the method listed about and/or use if not Request("checkboxname")="" then strSQL = "delete from table where primarykey in ('"&replace(request("checkboxname"),",""','"&"')" end if This assumes that there are no single quotes in the pk value. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: pedalcars
Date Posted: 17 June 2003 at 8:43am
|
After a couple of false starts (my fault), MorningZ's method is what I've gone for, thanks. Working fine now.
------------- http://www.pedalcars.info/ - www.pedalcars.info The most fun on four wheels
|
Posted By: Gary
Date Posted: 17 June 2003 at 8:47am
|
Another thing worth considering..... If you use either Morningz or my method, you will be hitting the database multiple times (once for each deletion). Whereas if you use ljamal's suggestion, only 1 hit is required as it will handle all of the deletions in one go. Why do I have to always over complicate things ??? lol |
Posted By: ljamal
Date Posted: 17 June 2003 at 10:10am
|
With my version don't forget to execute the SQL statement ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: MorningZ
Date Posted: 17 June 2003 at 10:43am
|
================================== nice snip of code.. very nice..... as for non-numeric primary keys mentioned above.... bad bad baaaaad database design if that's the case ------------- Contribute to the working anarchy we fondly call the Internet |
Posted By: Gary
Date Posted: 17 June 2003 at 10:57am
|
Morningz, I agree about the non-numeric pk's, but it does happen - believe me !!! |
Posted By: pedalcars
Date Posted: 19 June 2003 at 5:12am
Hmm, very nice. I've now switched to this given the one-hit nature. Thanks! ------------- http://www.pedalcars.info/ - www.pedalcars.info The most fun on four wheels
|
ljamal wrote: