ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: lambertb on February 20, 2006, 07:57:31 am

Title: Sequence Number for All Members
Post by: lambertb on February 20, 2006, 07:57:31 am

Hi,

I just imported about 800 people who were part of a series on my other system

They will all have a sequence number of "1" if I turn on follow ups.  I want to put them all to number "8".  and then back fill 1-7 for the new subscribers who come along behind them.

If I put in 1-7 right now, the people will get #1.  I will also have to click on all 800 to manually do it.

Is there a way to insert into the SQL table the sequence number of 8 for all subscribers in there now?  Even if they have never "technically" had 1-7 on my listmail system?

Brian

Title: Sequence Number for All Members
Post by: DW on February 20, 2006, 03:05:42 pm

Brian,

While this is possible in a near-future update, currently you must run a custom SQL query using PhpMyAdmin (often available in your hosting Control Panel), such as:

Code: [Select]

update lm_users set cseq = '8' where list = '1';
Regards

Title: What about different lists?
Post by: lambertb on February 20, 2006, 03:51:37 pm

Great! Thanks!

Will that apply to all my lists?

What if I have 10 lists.  

List 1: needs to be at 8

List 2: needs to be at 12?

List 3: needs to be at 1?

etc

Thanks Dean!

Brian

Title: Sequence Number for All Members
Post by: DW on February 20, 2006, 04:21:48 pm

Code: [Select]

update lm_users set cseq = '8' where list = '1';
In the above query the Seq # is 8 and the list is 1.  You can change these to your liking to update users on other lists.

Regards