|
1. More Types
In the stored procedure [DSC_EmailCampaign_GetAllMailingList] the SQL returns a result set of types 1,2 and 3.
The last bit of the s/p returns type '4 + emailListId', where 'emailListId' refers to table [DSC_Email_List_lkp] which contains one entry for 'News Letter'.
Can you confirm type '4' and above is for use with the 'subscribe' block?
I want to extend the options for example by adding 'Last 6 months active subscribers'.
Can I simply add more SQL and use type '4' and amend the SQL for '4 + emailListId' to '5 + emailListId'? Where else is 'type' used?
2. Subscriber Templates
For additional templates, I assume I have to manually add records to table [DSC_Email_List_lkp] and then amend the Subscribe Block to offer the user a choice?
3. Subscribe Block
When I add a 'subscribe block' and then 'add' an email address using that block on a live page, the system then displays another page, 'Home > Subscribe', with an email box and 'subscribe' button.
Is this the correct behaviour? Why not stay on the same page as the 'subscribe block' is placed on?
|