Print Page | Close Window

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")
     strSQL = "DELETE FROM Table WHERE ThisID = " & Replace(CheckedBox,"'","''")
     objConn.Execute(strSQL)
Next



-------------
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

==================================
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
==================================

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
Originally posted by ljamal ljamal wrote:

if not Request("checkboxname")="" then
   strSQL = "delete from table where primarykey in ("&request("checkboxname")&")"
end if


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




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net