OpenEMM Technical Support Forum

Hi together,

I try to fill the table "mailing_mt_tbl" with informations via SQL statment but I can't fill the attribute "param".
Can anyone help me?

best regards

Atteched, you find my SQL Query
INSERT INTO EMM...mailing_mt_tbl
(
mailing_id,
param,
mediatype
)

SELECT
mail.mailinglist_id
,CONVERT(TEXT,
(
N'from="' +email_sender_name +' <' +email_sender_address +'>",'+
' subject="' +Email_Subject +'",'+
' charset="UTF-8",'+
' linefeed="72",'+
' mailformat="1",'+
' reply="' +email_sender_name +' <' +Email_Bounces +'>",'+
' onepixlog="button",'
)
) parameter
,0 mediatype


from EMM...mailinglist_tbl mail
join EMM...epi_cell_stage stage
on mail.campaign_sskey = stage.campaign_id

Hi,

I found a way.....

Thanks