Hi ,
I am ussing a sqlexecutor for update or insert data in tables.
But how do i get the rows updates, inserted ??
so i use this in a Emailer ??
Hi ,
I am ussing a sqlexecutor for update or insert data in tables.
But how do i get the rows updates, inserted ??
so i use this in a Emailer ??
If I’m understanding your question correctly, you have a set of features you’re passing through an SQLExecutor to insert/update into a table. You’re then wanting to send an email with these features.
The SQLExecutor has the initiator output port, this outputs the features passed in through the initiator input port. I’m assuming you’re only wanting to send one email, so you need to reduce the number of features down to one (if you pass ten features to an emailer, you’ll send ten emails).
There are numerous ways to do this. For your situation, I think the HTMLReportGenerator will be helpful. This will allow you to build a table with the features that can then be inserted into the body of an email.
what i want is:
The nummers of rows insert/updated in a SQLExecutor.
Get the nummers and send this via an emailer
Hi
Hope that helps!