Hi,
I have searched the forum to help me build new newletter groups. I will be using the group pricing field to distinguish these groups. I have three new groups that I set up in group pricing(volunteers, supporters and sponsors)
I found a few posts that recommend to add via install SQL patches this SQL stmt to add the volunteers group. This is what I processed:
I am getting this error in both the newletter and send email mgrs:INSERT INTO query_builder (query_category , query_name , query_description , query_string ) VALUES ( 'email,newsletters', 'volunteers', 'Newsletter subscribers who are in the volunteer group', 'select c.customers_email_address, c.customers_lastname, c.customers_firstname, c.customers_group_pricing from TABLE_CUSTOMERS c, where c.customers_newsletter = \'1\' AND c.customers_group_pricing = volunteers GROUP BY c.customers_email_address order by c.customers_lastname, c.customers_firstname ASC');
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where c.customers_newsletter = '1' AND c.customers_group_pricing = 'volunteers' ' at line 1
in:
[select c.customers_email_address, c.customers_lastname, c.customers_firstname, c.customers_group_pricing from customers c, where c.customers_newsletter = '1' AND c.customers_group_pricing = 'volunteers' GROUP BY c.customers_email_address order by c.customers_lastname, c.customers_firstname ASC ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Can anyone guide me to where I'm going wrong. WARNING - SQL - newb.
Thanks sooo much!
MC
Bookmarks