Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    78
    Plugin Contributions
    0

    Default Need SQL code checked for splitting up newsletter groups?

    I found this code for making groups in emails but i just need to make sure it is correct after i modified it. I am running 1.3.7 I want to have a group of of customers that starts with 1 and goes to 450 with the ID here is my code
    INSERT INTO query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Newsletter to Test Account Only', 'Send sample newsletter to Customer Test Account only', 'select customers_email_address, customers_lastname, customers_firstname from TABLE_CUSTOMERS WHERE customers_id = \'>450\'');

  2. #2
    Join Date
    Oct 2005
    Posts
    78
    Plugin Contributions
    0

    Default Re: Need SQL code checked for splitting up newsletter groups?

    I figured it out with a little training on sql programming

 

 

Similar Threads

  1. newsletter checkbox default checked - legal in California?
    By fakeDecoy in forum General Questions
    Replies: 1
    Last Post: 14 Jun 2011, 08:36 PM
  2. Replies: 2
    Last Post: 24 Mar 2011, 06:54 AM
  3. Display checked newsletter subscription checkbox legal in U.K.?
    By OK Computer in forum General Questions
    Replies: 0
    Last Post: 20 Jun 2006, 03:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg