homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Delete multiple records from database using textarea

10+ Year Member

Msg#: 3477303 posted 7:07 pm on Oct 14, 2007 (gmt 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.



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

Msg#: 3477303 posted 10:27 pm on Oct 15, 2007 (gmt 0)

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


10+ Year Member

Msg#: 3477303 posted 11:27 pm on Oct 15, 2007 (gmt 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!

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved