Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Delete multiple records from database using textarea

7:07 pm on Oct 14, 2007 (gmt 0)

Junior Member

10+ Year Member

joined:Apr 2, 2004
votes: 0

I have a Access database email list with several thousands entries. I would like to find a way to simply cut and paste all email addresses that need to be removed utilizing a textarea field on a .asp (vbscript) page.

I have Googled this until my fingers bled, thought I'd ask if anyone here knew of a good tut or resource that could help me with this?

Thanks in advance.

10:27 pm on Oct 15, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:Dec 27, 2004
votes: 74

I am not sure what the exact ASP Would be but here is the logic:

you form
<form method=post>
<textarea name=emaillist></textarea>
<input type=submit>

your script logic

magic_string = you will need to take the value of form.emaillist, add ticks around individual value, make sure its a list(csv format or tsv)

then use delete query where emal_field in(magic_string)

something like that..

11:27 pm on Oct 15, 2007 (gmt 0)

Junior Member

10+ Year Member

joined:Apr 2, 2004
votes: 0

Thanks for the tip, Blend. I have found a couple of scripts that I believe can be adapted. Was searching Google for "Delete", and "textarea". Stumbled upon a script that "inserts" multiple records from a textarea that can be modifed to delete using the same logic.

I guess it is true what they say about thinking outside the textarea!

I post my code when I get it to work. Thanks again!