Hi all,

is there any easy way to get a result set out of an query into an e-mail dirctly through vc?

something like a simple sql-query:

select name from plahh
where something

would give me a list of names and I would like to send those by e-mail somewhere.
But right now I can't find any variable that seems to containt hat data within vc.

Maybe I oversee the right way for doing that.

Thanks in advance.
Regards,
Ives

You could perform your select. Then use the Replace function in Variables to replace \n to ;. The result can be put in the recipients text box.

---

Hi Henrik,

I still don't get it - which variable does contain the result of the query?

I can't find any vc-variable that would give me those data - so I can't replace anything and replacing \n is not my problem. As I just would put the list of names inside the body of the e-mail but as I can't access the resulting names of the query I can't send it by e-mail to somewhere.

Thanks for your patience.
Regards,
Ives

It is the Task output Variable. Open the Variables browser. Open the Job. Find the Task. Open the Output Variable and you will see the content. Copy that Variable.

---

Ah cool, yes.

I had that already in but the result set change to nothing, so I modified the filters and now I see it in the normal output. Just didn't realize there was nothing there and then it's of course empty.

Little tricky things 😉.
Thanks for helping.