Welcome to WebmasterWorld Guest from 54.163.168.15

Forum Moderators: open

Delete multiple records from database using textarea

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

10+ Year Member



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)

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



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

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)

10+ Year Member



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!

 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month