MX Send E-mail Forum :: Custom trigger after insert tranaction

Hi there,

I have a little problem. I'm making a webshop. When someone has paid, I would like to insert a payment in my database. That's no problem. After the (automatic) insert transaction should be a Send email with conformation of the order. All data in the email is from the database not from transaction fields.

When I send an email with a form I change some data, for example the price in the field/database is 1234.69 and I want to display it 1.234,69.
I put a custom transaction before the e-mail sending:
$_POST['totaalprijs_ord']=number_format($_POST['totaalprijs_ord'],2,',','.');
And in the HTML of the email: {POST.totaalprijs_ord}
No problem, everything going well.

But when I'm sending this data from the database, the custom trigger doesn't change anything. I tried this in the custom trigger:
$row_RE_order['totaalprijs_ord']=number_format($row_RE_order['totaalprijs_ord'],2,',','.');
And in the HTML of the email:
{RE_order.totaalprijs_ord}

The trigger doesn't work. The trigger is after the insert transaction and before the send email.

Do you have a solution for me? Or can change the "price" on a different way in the email?

Kind regards,

M.L. Stikkelman

Hi,

I don´t think that Custom Triggers are able to access values derived from a recordset.

Cheers,
Günter Schenk
Adobe Community Expert, Dreamweaver