ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => Development, Suggestions => Topic started by: sam0812 on November 01, 2004, 08:23:45 am

Title: How can I delete a select number of users?
Post by: sam0812 on November 01, 2004, 08:23:45 am

I want to select 20 out of 30 users to delete.

How can I do this without having to click
on each individuals delete button?

Title: How can I delete a select number of users?
Post by: DW on November 01, 2004, 11:30:15 am

This is currently not possible.  A future release will feature checkboxes as you would expect from a professional program.. :)  For now, I recommend clicking the Delete button next to each user and hitting Enter.  This method can be reasonably fast for up to a few dozen users.  My apologies for the inconvenience.

Title: delete a select number of users
Post by: sam0812 on August 22, 2006, 06:04:35 am

Hi,

I would like to delete all of my AOL users from my Active list.
Is there a fast way of doing this without having to press the
delete button next to each user?

Thank you.

Title: How can I delete a select number of users?
Post by: DW on August 22, 2006, 08:49:49 am

Do you know how to do custom SQL queries with PhpMyAdmin?

Alternately, you can login to ListMail and browse to editconf.php?customcmd=1

The query to permanently delete all aol.com users from list 1 would be:

Code: [Select]

delete from lm_users where email like '%@aol.com' and list = '1';
And to remove them from all lists

Code: [Select]

delete from lm_users where email like '%@aol.com';
Regards :D

Title: How can I delete a select number of users?
Post by: sam0812 on August 22, 2006, 09:41:40 am

Hi,

I get a "failed executing command" error when trying
to use the code:
delete from lm_users where email like '%@aol.com' and list = '1';

Are you sure that's the correct code to use?

Thanks.




---------------------------------------
Alternately, you can login to ListMail and browse to editconf.php?customcmd=1

The query to permanently delete all aol.com users from list 1 would be:
Code:
delete from lm_users where email like '%@aol.com' and list = '1';